Hi
Is there any way to export the results of two Crosstab queries into a single Excel Worksheet, specifying destinations for each fields result using VBA?
I am looking at placing the code in a buttons On_Click event so that the user doesn't have to manually copy the results into the Spreadsheet, therefore eliminating the risk of human error when sending out figures to management.
I have attached a copy of the Database and the Template Spreadsheet. The queries in the Database to be exported are "7e Completion by Manager Append_Crosstab" & "8f Progress Against Test Plan Append_Crosstab" and a quick look at the Spreadsheet should show where I want the results to go.
Thanks in advance!!!