Merge all worksheets in excel workbook?

October 7, 2010 at 08:06:55
Specs: Windows XP
I need to merge 16 whole worksheets in my excel workbook, with results in worksheet 17. All laid out identically. Need averages to be produced as one result, and in another result need sum. How do I accomplish this?

See More: Merge all worksheets in excel workbook?

Report •

October 7, 2010 at 08:56:08
You'll need to define "merge" in a little more detail.

Are you trying to get all of the data from the 16 sheets into Sheet 17 or are you trying summarize certain cells?

e.g. =SUM(Sheet1!A1,Sheet2!A1,Sheet3!A1)

Report •
Related Solutions

Ask Question