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.
18 freelancers are bidding on average $108 for this job
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 - 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,