Forum Discussion
Need to extract values from named cells (Get and Transform)
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.
I duplicated your folder
C:\Users\Jema\Veidekke\NO-ENT-GLENCORE Cu-Bygg - Teamdokumenter\Intern Prosjekt Dokumenter\10 Økonomi\10.04 Endringer\Endringsmeldinger (EM)\EM\EM001 - Tilleggsarbeid med kranfundamenton my computer, Power Query works with 3 test files inside. Please check with attached file.
Checked once more your file and see that all files are in different folders
Is that correct or you use only first one?
We use a seperate folder for each file, as this is a Collection of files that belong to that particular change-order. So far there are some 65+ folders with .xlsx files (plus various other files) inside that we need to Query for the result of the 3 named cells in each file.
So it´s correct that the files are in a lot of different folders under the main folder /EM
Best regards
Jesper
Hi Jesper, great to know you sorted this out.
Hello Sergei,
Hope you had a fine weekend. The file worked With a few modifications, I had to insert 2 steps, one for sorting alle files as .xlsx only and another sorting as EM(Space) only, as this is the files from where the values are of interest.
Working great now, thank you very much for Your kind assistance.
Best regards
Jesper
- Thank you Sergei,
I will test it out on monday, have a fine weekend.
Best regards
Jesper 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.