i,
Im familiar with SQL queries and so Im thinking I should be able to achieve a query within Excel - am I right
????
What I would like to do is - I have a sheet which imports data from an external source and data extracted from another source - both of which could contain multiple invoice numbers. I would like to be able to show those complete orders on a 3rd sheet based on the order number within the cell. I have attached an example which shows DataA (which would be the SQL data) DataB another source of data and then combined data which has the invoice number atthe top and then would pull through from the other 2 worksheets the data.
Thanks