Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to create a consolidated excel worksheet?
I have 5 data sheets in one excel document, now I need to create a consolidated worksheet that summarizes the data grids from 5 sheets. How do I do it? step-by step instructions please. thanks so much...
|
#2
|
|||
|
|||
Quote:
Hi Sort all the columns in the all the sheets based on name say Column A and in the final sheet consolidated sheet, just use sum of sheet1 column A2+sheet2 ColumnA2...... If you have to do this task on regular, basis. Record a macro. That might help you avoiding of manual task every time. thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I merge 2 worksheets into one consolidated worksheet? | Excel Discussion (Misc queries) | |||
How to consolidated (export) excel file as soon as I receive as ma | Excel Discussion (Misc queries) | |||
How does Excel determine the ORDER of consolidated data? | Excel Worksheet Functions | |||
how do i recover a consolidated worksheet that i sorted/subtotale | Excel Worksheet Functions | |||
Consolidated Excel Sheet | Excel Worksheet Functions |