Hi, I've created a query that extracts data from a specific sheet in a folder and it's working fine. Now, I need to add another column to the table that is returned, and get the value is in a specific cell (G4) of a different sheet in the same files in the folder. Any pointers are most appreciated. TIA, Paul
Hi Paul,
Create a new query to get the data from cell G4, then add a column to the original query =#"New Query Name"
Mynda
Thanks, Mynda, that's working fine. At present, the second query is created by removing the other rows and columns (leaving the single cell G4); is there a better way? Cheers, Paul
What do I need to do so that the new query doesn't load to another worksheet?
And I'm unable to download the data, I'm getting an error msg: [Expression Error] The key didn't match any rows in the table. Any suggestions appreciated...
Hi Paul,
Not sure there's a better way to isolate cell G4 that what you've probably already done.
When you 'close and load' choose Connection Only if you don't want it to load a table to the worksheet. If it's already loaded, right-click the query in the queries and connection pane > Load settings - here you can edit the load settings to connection only.
The Expression Error is caused when you have a hard keyed name (sheet, table, column) in the query that is no longer in the source data the query connects to. i.e. it's looking for a specific name and it can't find it.
Mynda
Thanks, Mynda. It's sorted.
