Hi all,
I'm very very new to working with Macros, but I'm trying to create one to pull data from multiple spreadsheets into one master spreadsheet (the number of rows will be a variable).
I will have 10 spreadsheets titled:
DB
DL
HC
HE
JC
KB
MB
MNC
NS
SM
Then a master
The columns will be from A2 - AK2 (again the number of rows will change daily)
Is there any sort of macro that can pull the data from all 10 spreadsheets and place them into a single master spreadsheet? I need to be able to do this throughout the day so I can run reports.
Any help would be really appreciated!
Thanks a bunch!
Bookmarks