Forum Discussion
Extracting named cells from multiple sources
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.
Hi, thanks for being patient!.
Yes, there are three sheets. I only want to pick up data from the first sheet as the second two are contain lookups and notes.
The pronlem I have is that 'One page Summary' isn't formated as a table. I need to select fields to convert into a query table from a small sample of the named celss you can see below the sheets.
A small sample of the One Page Summary sheet below:
You need to piece together a single row from this table like:
Table.FromRecords({[#"Project Status" = PreviousStep[Column6]{1}, ...]})
Where Column6 is the column with the value for Project Status, and 1 is (row number - 1) of that value. Repeat this for all items in the table (Hopefullly no one moved stuff around in other workbooks). If done correctly you should have a table with 1 row.