Cross Post [url]https://www.mrexcel.com/board/threads/dynamic-sheet-name-power-query.1224468/page-3#post-5989703[url]
Hi, I import date from another excel file via Power Query. The sheet names change monthly. I want to feed the required sheet name to the Power Query. Cant get it working.
used the script below:
Power Query:
l
---
the sheet name is defined in range name mySheet = December 2022 (the sheetname is in date format - 1/12/2022 - MMMM YYYY )
Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=01/10/2022 00:00:00
Kind=Sheet
Table=
I manually changed the sheet name to text and the dynamic name to the same and get the same error
Bookmarks