Consolidate workbook template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on consolidate worksheets from different workbooks into one 2
consolidate workbooks to worksheets in one workbook? 1
Copy cells from 4 w'sheets in multiple w'books to 1 w'sheet in 1 w'book 0
Trace links between worksheets within one workbook 4
Totals from Seperate Worksheets to One Consolidated Sheet 6
Need macro to consolidate all sheets in workbook 1
PROGRESS BAR 2
Problem with consolidation 0

Back
Top