ADD CELLS FROM DIFFERENT WORKBOOKS IN EXCEL

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

Guest

I have a summary worksheet with several others as back up data - ie company
budget summary with branch budget worksheets. I need to add various totals
(expense headings) from each worksheet and consolidate on summary worksheet.
Regret I am a basic user of Excel. Hopefully someone can guide me. Thank you
 
Workbooks or Worksheets?

Your subject and description do not match.

I will assum worksheets..............

If the total on each sheet is in the same cell on each sheet you can 3D
reference.

Add a new sheet after the Summary sheet which I assume is first in book.

Name this sheet Start.

Add a new sheet at end of book and name it End

On Summary sheet =SUM(Start:End!H34)

If not in same cell, lotsa work<g>

You could perhaps group the sheets and manipulate rows and columns so's you
get the total on each sheet in the same cell?

Anything that would distinguish the placement of the total cell on each sheet?


Gord Dibben Excel MVP
 

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

Multiple workbooks 1
Excel lookup across entire workbook 1
Add 6 worksheets in workbook 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel workbooks 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Indirect references with VLOOKUP 5
display worksheet name in a cell 0

Back
Top