Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ADD CELLS FROM DIFFERENT WORKBOOKS IN EXCEL
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 |
#2
|
|||
|
|||
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 On Mon, 16 May 2005 14:18:23 -0700, "Consolidating totals in Excel" <Consolidating totals in wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
Calculating Cells causes Excel to stop responding | Excel Discussion (Misc queries) | |||
Excel workbooks in different windows & Fill color? | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions |