Forum Discussion
Solved
Excel Tab Name Changes
Hello, I get a new data file (Excel) each week. The file gets saved over last week's report (Same file name). The Excel tab name changes to match the week #. It has the naming covention Week ## (...
Hi,
Follow the steps shown in this video - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks.
Hi,
Follow the steps shown in this video - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks.
The technique of removing the tab names in this view worked like a charm! Thanks!!
You are welcome. Thanks to the creator of the video.