Forum Discussion
Extracting named cells from multiple sources
Hi - many thanks for the solution. I managed to go all the way through without error, but only getting a table with a list of the files, creation date etc...not the slected cells.
Can I clarify Step 2? When I start to import the file into a query, I get this screen:
Do I select my chosen data items at this point and do I use load or transform.
What I am not getting automatically is seeing the gear next to the source step.
Darrin
Make sure you are loading the data from a file, not the current workbook. Just transform the data.
You seem to be missing step 8 where you invoke the function to get to the data.
Hi Anonymous
What are the positions of the selected named cells? Are they always in a sheet with a specified sheet name and are at the same positions in all files?
In step 2, you will see all sheets and tables in a file. You need to select the sheet where you want to extract data from and click transform data to go on transforming it.
Best Regards,
Community Support Team _ JingThanks. I'm still having problems and I think it might be step 2 that is doing it.
As per my previous attached pic, If I select just the sheet 'one pager' I get presented with a table with multiple unnamed colums, but I can see the data is visible in the tabke, but not against the cell reference names I want. If I choose a small number of cell names in step 2, then I dont get visible data at all.
The top entries in step 2 are the sheet data... the items below that (with a different icon) are the tables in that sheet. If you just need one of those tables you can use that. If you need multiple tables, but they are independent, you can repeat these steps for each one. If you need to combine the tables in some way, then the solution becomes more complex and what you need to do depends on how these tables interact with each other.
