Hi
I'm trying to collate data from multiple worksheets (90+) into 1 summary sheet. The data is the the same cells references within each worksheet (130 cells to be copied from each worksheet).
Any ideas will be greatly appreciated.
Hi
I'm trying to collate data from multiple worksheets (90+) into 1 summary sheet. The data is the the same cells references within each worksheet (130 cells to be copied from each worksheet).
Any ideas will be greatly appreciated.
Perhaps you should try Data, Consolidate...
Best regards,
Ray
Hi Ray
Thanks for the reply.
I had had a look at this option but wasn't sure what function would be required to copy the contents of the cell. Do you know what to use?
Thanks again
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks