I can't get my brain wrapped around this one.
I have a select query and 2 crosstab queries that I need to combine and export to Excel.
The crosstab queries have the following columns
Crosstab# 1
Product - row heading
Country - Column heading (creates 5 columns)
Country Qty - Value
Crosstab #2
Product - Row heading
Region - Column heading (creates 5 columns)
Region Qty - Value
The spreadsheet needs to have all of 10 of the columns next to each other but I can't figure out how to combine the 2.
I can't do a Pivot table as the data is being used to populate other workbooks with VLookup (let me know if I'm wrong on this one) and will be refreshed periodically from the Access queries.
Thanks!