Excel Macro/VBA - Summarize Table Data and Lookup New Fields
$30-250 USD
Paid on delivery
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.
Project ID: #17489899
About the project
Awarded to:
Hello, I can help to deliver this with quick turnaround. Looking to hearing from you soon. Kind regards, Rina
17 freelancers are bidding on average $105 for this job
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
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
Hello. I have good skills in Excel/VBA. I have read your project description carefully and i can do it. Contact me please. Thanks........................
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
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,
I have been programming for more than 20 years in Excel VBA macros. Please contact me via chat if you have any questions.
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
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
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
