Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks. 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.

artemus's avatar
artemus
Microsoft Employee
4 years ago

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.