Forum Discussion
importing data from multiple worksheets into one table
I have 50 worksheets all containing audit results using the exact same questionnaire. Names, elements, scores, etc are all in the same location in every document. Is there a way to automatically gr...
When you say "worksheets" are you speaking of 50 separate files, each its own Excel workbook?
It is indeed possible to retrieve data from cells in other workbooks; it's easier to retrieve data from cells in other sheets in the same workbook.
Without knowing more, I'd recommend that you look into the INDIRECT function. If they are separate workbooks, then you will need to have them all open in order to access them, but it will work....... So INDIRECT would be where I'd start.