Consolidate workbook template
 

Hi, I am going to create a template for department budget, how can I easily
consolidate them all in one file with total amount after department manager
finish their respective worksheet on the template? Let's say, I have ten
workbooks with same format and layout that I get from different managers,
What tool I can use in MS excel to consolidate them to one workbook?

Thanks a lot,

Hank

Consolidate workbook template
 

Hi Hank, two options:

1st - put all worksheets in the same workbook and create a total with
formulas

=sum(sheet1:sheet10!a2)
copy for corresponding cells

2nd - put all worksheets in the same workbook and in a blanck one DATA |
CONSOLIDATE.

Add the ranges and OK

hth
regards from Brazil
Marcelo

"Hank" escreveu:

Hi, I am going to create a template for department budget, how can I easily
consolidate them all in one file with total amount after department manager
finish their respective worksheet on the template? Let's say, I have ten
workbooks with same format and layout that I get from different managers,
What tool I can use in MS excel to consolidate them to one workbook?

Thanks a lot,

Hank