I've been given an excel file that has 75 worksheets. (A database was dumped into Excel 2003 that had a 65,000 records per sheet limit)
I need to combine the information from all the sheets into one. (The fields are the same in all worksheets)
At this point, I'm looking forward to a long evening of cutting and pasting.
Hoping someone knows a better way.
Many thanks.
Bookmarks