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...
Debbie57 Alternatively, look into Power Query (a.k.a. Get & Transform Data) to connect to all files in a Folder (in case you have 50 different files) or all sheets in a workbook (if that's applicable in your case).