Forum Discussion
I need help!?!
Good day all, Layout - - Workbook 1 will be the main workbook with a multitude of worksheets. - Workbook 2-6 will have a multitude of worksheets with dates as sheet names. The Challenge - Ho...
One way is to use INDIRECT, but for that all workbooks shall be opened.
Another way keep wokbooks 2-6 in the folder (or SharePoint folder), by Power Query get data from all of them, from each sheet for the workbook, transform keeping only necessary data, combine and load result into helper sheet of the workbook 1. Here XLOOKUP needed data from.
But that's all very depends on how exactly your data is structured.
Thank you for your response. I am trying to avoid keeping all workbooks open. The other workbooks are on a SharePoint folder. Would the other workbooks need to be formatted as tables to pull specific data or is there a way to do this without creating tables?
Thank you.
