consolidate excel file

Hi all, This is a fairly common question, and is regarding creating a VBA code to pull multiple dataset from different excel files and consolidate them into one master spreadsheet. All files have the same format, same columns but different number of rows. However, with my situation, in each...

All, I am trying to write a macro within a central model (let's call this the 'aggregator model') to open a series of spreadsheets (one at a time), then copy data and paste as hardcoded values into the central model. The main difficulty I can see, is identifying the area where the data should...

Hi, Need help with Macro. I have many excels in many subfolder. They are all part of one Parent folder. Each subfolder has two excels. The name of each subfolder starts with same word as the first word of excel that subfolder holds. Each excel has one worksheet only. I need a macro that runs...

Hello Everyone, I have multiple excel files in a folder with names "A 08-24-16 File1", "A 08-24-16 File2", "B 08-24-16 File1", "B 08-24-16 File2", etc.. I need help with VBA/Macro to combine two excels with same first name (in this case all A together, then all B together) with the output name...

Hi Friends, I am struggling to search a piece of excel macro which can do the following steps for me : 1. I have individual excel sheets in 3 folders where the name of the file is the same and an unique identifier for example : 1_test1.xlsx in folder C:\Macro\test1; 1_test2.xlsx in folder...

Hello Folks, I have approximately 1000 sets of 80 excel spreadsheets. I am trying to combine each of these sets of 80 spreadsheets to produce one main spreadsheet for each of the 1000 sets. Basically at this stage I would need to copy and paste data from each individually, onto one central...

The issue I have is, I have 9 Excel Files that shared with multiple users. All of these workbook and sheets fully protected. Each workbook has 30 sheets and conditional formatting. I have a master file that exactly identical to these sheet. [ basically this master file has 30 sheets with the...