Hi everyone,
I have a bunch of spreadsheets where numerical data (reference numbers) has been arranged into columns in multiple worksheets.
Spreadsheet Example.JPG
I've attached an image of my spreadsheet, as I can't seem to upload a file to the forum at the moment.
As you can see in the image, I have a spreadsheet with three columns of data in a worksheet. There are 41 separate worksheets within the spreadsheet, all with data in the same format.
I need an efficient way to combine all the references in all 41 'Column A's into one list. Essentially merging the data from the 41 worksheets into one single worksheet (with three columns of data).
However, I haven't been able to find a means of doing so, and am left with no option but to copy & paste them.
Is anyone aware of a method or function within Excel that would permit an expedient way to collate the references into one worksheet?
More than happy to expand on any aspect of this query, should it not be entirely clear.
Thanks everyone!
Bookmarks