Completed

Excel Macro/VBA - Summarize Table Data and Lookup New Fields

I need to manipulate a data file I will receive each month (similar to attached). The data file includes a list of managers (Column B-D) and all of his direct reports (Columns H-AB). I want the file to create a table from the original showing a summary table detailing each managers direct reports on a seperate row (see summary sheet for example). The example below has 3 rows of data, but the actual file may have >30,000 rows, so the Macro must be able to handle many rows. Once the summary sheet is created, it should vlookup data from the Details tab to the Summary Sheet for 3 columns. The final summary sheet should include a list of each manager and each individual direct report on a separate row, as well as the 3 columns of vlookup data.

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: excel macro copy selected cell data cell, example excel macro vba invoicexls forum, excel macro add row fill data, excel summary function, excel summary table formula, excel vba match value in range, excel summarize data without pivot table, application.match excel vba, excel macro match, unable to get the match property of the worksheetfunction class, excel vba match index, excel multiuser vba access table, excel macro vba select copy paste internet explorer, excel macro vba functions cut paste, excel macro visit website pull data, excel macro import file parse data, excel macro vba odbc querytable, excel macro choose tab paste data, excel macro input large amount data, excel macro vba find word

About the Employer:
( 2 reviews ) green brook, United States

Project ID: #17489899

Awarded to:

rinabuoy13

Hello, I can help to deliver this with quick turnaround. Looking to hearing from you soon. Kind regards, Rina

$55 USD in 3 days
(42 Reviews)
5.1

21 freelancers are bidding on average $115 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$200 USD in 2 days
(604 Reviews)
8.3
schoudhary1553

Hello, I can help with you in your project Excel Macro/VBA - Summarize Table Data and Lookup New Fields I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for More

$160 USD in 3 days
(275 Reviews)
7.6
seaanddream

Hi, my name is Selim. I read your "Excel Macro/VBA - Summarize Table Data and Lookup New Fields" project descriptions carefully before bidding. I checked the attached template as well... I got what you need and ready More

$150 USD in 3 days
(293 Reviews)
7.7
SShtv

I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots of some of my works. [login to view URL] More

$100 USD in 2 days
(59 Reviews)
5.6
mail2vimalarora

Hi, Being experienced in handling excel functions/vba macro related tasks extensively, I can take up the task to complete quickly and efficiently. I assure you of quality work and making any other minor changes as per More

$45 USD in 1 day
(81 Reviews)
5.7
supergana

Hi - I have built complex macros that manipulate csvs of over a million rows in size so what you have mentioned does not sound scary to me. Lets discuss if you are interested and take it forward. Regards,

$138 USD in 3 days
(21 Reviews)
4.2
$300 USD in 3 days
(5 Reviews)
4.1
Salesj23

hello there I am an excel vba developer and expert with experience in working on various of projects of dynamic vba utilization as for your project here I have code to split and vlookup using vba as per your projec More

$66 USD in 4 days
(11 Reviews)
3.5
lightingdavid

Hello. I have good skills in Excel/VBA. I have read your project description carefully and i can do it. Contact me please. Thanks........................

$155 USD in 3 days
(2 Reviews)
3.0
rickygzz85

I have been programming for more than 20 years in Excel VBA macros. Please contact me via chat if you have any questions.

$55 USD in 1 day
(9 Reviews)
3.1
$60 USD in 3 days
(5 Reviews)
2.1
ananthgadag

Hi, I have an experience of 8 years working on excel macros. I am currently working as a freelancer on a full time basis and I would be happy to help you get the work done for you. Kindly allocate the project so tha More

$30 USD in 2 days
(6 Reviews)
2.0
DesignEnlight

Hello, I am an excel expert with 10+ years of experience in generating reports from excel. I have 200+ reviews on my profile & I can provide you best results within given time & budget. Vlookup for VBA, I have d More

$80 USD in 0 days
(0 Reviews)
0.0
$150 USD in 3 days
(0 Reviews)
0.0
GeoDelhiExcel

Excel Automation using VBA and DB Solutions with ACCESS / Excel Training (Basic, Adv & VBA/MACRO) I worked in various engineering companies where i was responsible for processing engineering data generated from vari More

$55 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
msn131

Hi, i can do the job.

$155 USD in 5 days
(0 Reviews)
0.0
johnAlexander2

Hey! I'm John Alexander I have reviewed your complete job description. I have fully understood your requirements and I fulfill all the qualifications required for this project. Quality work is my Priority. Let’s More

$50 USD in 3 days
(0 Reviews)
0.0
revocoq

HIGHLY interested with your project. I'm ready to start right now. I'm an individual developer and my completion rate is always 100%. I STRICTLY BITE only WHICH I CAN CHEW. Knock me please

$150 USD in 3 days
(0 Reviews)
0.0
$111 USD in 3 days
(0 Reviews)
0.0