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="...

EM 003 - Oppsett.xlsx37 KB

Testfile.xlsx2.5 MB

BI & Data Analysis

excel

office 365

SergeiBaklan
Nov 29, 2019
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.
PQ Named Values from Files In Folder.xlsx25 KB

Forum Discussion

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

Resources