Hi,
I have a excel sheet containing about 10 worksheets. All the worksheet contain data with similar column headings..
Formatting data from these 10 sheets as tables, I am able to use msquery - union all and create a mastersheet combining all the data in a new excel workbook and generate a pivot report.. This also gets refreshed whenever the original data changes.
Unfortunately I am not able to figure out on how to get this done in the same workbook..
Any suggestion (using msquery) would be of great help
I have a excel sheet containing about 10 worksheets. All the worksheet contain data with similar column headings..
Formatting data from these 10 sheets as tables, I am able to use msquery - union all and create a mastersheet combining all the data in a new excel workbook and generate a pivot report.. This also gets refreshed whenever the original data changes.
Unfortunately I am not able to figure out on how to get this done in the same workbook..
Any suggestion (using msquery) would be of great help
