I have merged two queries based on one shared column of data into a new querie. However, when I try to "load and close" it does not populate anywhere I can find. I want it to populate on a new worksheet in the original spreadsheet but the "Close and Load to..." is not active and I can't get it to be active so I can choose the destination. I hope this is making sense...
Close Query Editor, in Excel Ribbon, Data select Queries & Connections, you will see list of queries. Right click on your query, from menu select Load To... and after that desirable option (Table, Connection only, etc.)
