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.
Hi again,
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
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
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.
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