Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
Combine multiple sheets.
Posted by - NA - on 01 April 2006 02:48 AM
|
|
|
Solution: 1.Open or create a Summary file and select 1st cell you want to start. 2.Select Data/Consolidate 3.Function – Sum 4,Reference – Click shrink box icon, click open sheet1, highlights all area with column heading and totals, click expands box icon, click Add, which will add to the All Reference column. 5.Continue to add all other sheets same as above. 6.Make sure turn on all “use labels in” lines. 7.Click OK | |
 (119 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)