Quote:
Originally Posted by Newellmyra
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...
|
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