Hi. Was wondering if anyone knew if there was an easier way to consolidate a large number of spreadsheets into one without doing a load of vlookups (due to them being large sheets and other people colleges adding new lines)?
For example are there any macros that can pick up a load of data from the other spreadsheets and past them into my consolidated spreadsheet without any hassle. Then perhaps have formulas to pick up the data from the consolidated workbook.
If the layout of the workbooks is the same, i.e. same columns, sheet names etc then a macro would be quite straightforward. This sort of thing is asked almost daily if you do a search of the forum. If you still need help post back.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks