Forum Discussion
ethanlsaul
Helper I
Helper IExcel 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.
ethanlsaulHelper I
Helper IThe technique of removing the tab names in this view worked like a charm! Thanks!!
Ashish_Mathur
Super User
Super UserYou are welcome. Thanks to the creator of the video.