Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Summarizing Data
I have several worksheets containing the same columns and data for different
entities. I need to create a summary worksheet that pulls all the data into one 'total' worksheet and gives me the ability to 'refresh' when I enter changes into my individual worksheets. I am just learning functions. Am I best to use Pivot Table, Consolidate or summarize some other way? Thanks for any help in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Summarizing Data
Here is an example using Excel 2007,
Pivot Table, Consolidate: http://www.savefile.com/files/1759919 |
#3
|
|||
|
|||
Quote:
Say sheet1 contains column name as employee, ID, Salary, sheet2 contains sames fields & similarly sheet3 also contains the same. Now there is a sheet called Total contains same columns Names Employee, ID, Salary, In Order to get consolidated information from three sheets 1,2,3 into total. step 1. In sheet Total, put columnA "=sheet1A1" ColumnB=Sheet1B1", ColumnC="Sheet1C1" and drag down till 1000 rows. step 2. from 1001th Row in sheet total 1001th row column A "=Sheet2A1", Column B"=Sheet2B1", Column C"=Sheet2C1" drag from 1001th row to 2000th row in total sheet step 3. Similarly drag 2001th row to 3000th row "Sheet3A1", "Sheet3B1", "Sheet3C1" in Column A, Column B, Column C. Step 4. Use pivot table in sheet "Total" for Columns A,B,C till 3000 rows. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing Data | Excel Worksheet Functions | |||
summarizing data | Excel Worksheet Functions | |||
Summarizing data | Excel Discussion (Misc queries) | |||
Summarizing data | Excel Discussion (Misc queries) | |||
Summarizing data | Excel Discussion (Misc queries) |