Forum Discussion
Extracting named cells from multiple sources
Hi, I have a number of project management templates that contain info such as project number, start and end date, RAG status etc. All files are in .xls format, sit in the same network folder, and...
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.