Forum Discussion
Solved
Need to extract values from named cells (Get and Transform)
Hi, I have made an Get and Transform Query on a folder with many subfolders all containing an workbook with the first sheet named "Endringsmelding" in each. These sheets contains 3 named cells: K5="...
If so your filepath shall be
C:\Users\Jema\Veidekke\NO-ENT-GLENCORE Cu-Bygg - Teamdokumenter\Intern Prosjekt Dokumenter\10 Økonomi\10.04 Endringer\Endringsmeldinger (EM)\EMAttached file works if another 3 folders are under above one.
Hello using Norwegian version of Excel 365 doesn't have issue with what you're trying to do....
However, there is only one sheet with data in the first Excel workbook uploaded and use question wasn't clear enough.
To use Power Query,your data must be arranged in the Excel way and converted using CTRL + T
However, there is only one sheet with data in the first Excel workbook uploaded and use question wasn't clear enough.
To use Power Query,your data must be arranged in the Excel way and converted using CTRL + T
I have Attached a testfile2 where the data tab is an Excel table.
Inside each of the listed files, is a worksheet with 3 named cells. I need to list the values of those 3 named cells in the worksheet "testfile2". Prefably the named cells (ranges?) should be dynamic, so user can insert an extra row without corrupting th result.
Am I making any sence?
