Hi Guys
From all your experience, what is the easiest and quickest way to consolidate many spreadsheets into one master spreadsheet?
Copying and pasting just takes ages and vlookups are not up for the job due to the volume and number of different spreadsheets. Is there a macro that can just pick password prottected sheets up and paste into a master sheet?
Basically I have say 10 to 15 spreadsheets that managers have to comment on sales figures on their area then I have a master spreadsheet that I want to consolidate everyone’s results and comments on one page rather than opening each area spreadsheet.
Many thanks for your help.
Bookmarks