Need to extract values from named cells (Get and Transform)

[JEMagnussen]

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

[#2 · Accepted solution]

@JEMagnussen 

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)\EM

Attached file works if another 3 folders are under above one.

[#3]

Thank you Sergei,

I will test it out on monday, have a fine weekend.


Best regards
Jesper

[#4]

@JEMagnussen 

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

[#5]

@JEMagnussen 

Hi Jesper, great to know you sorted this out.