Nov 29 2019 05:30 AM
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="EM", B11= "Beskrivelse" and L94= "Total".
I need to get those values in the named cells out and presentet in the workbook "Test" that I have Attached.
I have run the Get and Transfom Query, have the right folder as Source, so far so good. My problem is that I do not find any Reference to how to add New Columns with the values from the named cells?
Any help will be greatly appreciated.
Best regards
Jesper
Nov 29 2019 10:13 AM
SolutionIf 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)\EM
Attached file works if another 3 folders are under above one.
Nov 29 2019 10:47 AM
Dec 02 2019 12:52 AM
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
Dec 02 2019 07:55 AM
Hi Jesper, great to know you sorted this out.