I want to use sheet 1 to filter the query on Sheet 2
Posted on 2011-02-18
I have an Excel spreadsheet, sheet 1 finds all data of merchandise that has been returned. On sheet 2 I want to create a table that finds the location of where to put the returned items. I can create a query that combines 2 tables on ItemKey. However, I am getting all the data in Sheet2 instead of just the returned items. I created an external datasource using Data -> From Other Sources -> Microsoft Query, pointing to the Big Database and getting only the following : Table1.ItemKey, Table2.ItemKey, quantity and Location. where Table1.ItemKey = Table2.ItemKey. How do I limit the output to just the items in Sheet 1?