Question:
I have created three workbooks. Each workbook contains nine queries that all have the same selection criteria. What I need to do now is combine the three workbooks into one workbook so I can get my report by only executing one workbook. Can anyone help?
Thanks,
Mike...
Answer:
Use the Excel menu function Move Or Copy Sheet(s) to the other workbook.
Answer:
I used the excel function "Move or Copy Sheet(s)" that you suggested to create one workbook call "Combined". This workbook contains my three Workbooks (WB1, WB2 and WB3) as individual sheets within "Combined". The problem is that only sheet WB1 contains queries, while sheets WB2 and WB3 look like regular spreadsheets. When I refresh "Combined" it only refreshes the data in WB1 not WB2 or WB3. Am I doing something wrong when I do the Move or Copy Sheeet(s)?