Linking multiple excel sheets

  • Thread starter Thread starter xteven
  • Start date Start date
X

xteven

Hi I have a question... I am computing a lot of data in Sheet A. I want to
make some of the formulas keep a main tally on Sheet B, how do I go about
doing this?

Put bluntly, how do I allow data to flow from seperate indivdual excel
sheets?

(Cell in Sheet A) = (Cell in Sheet B) + (Cell in Sheet B)
 
xteven,

In the cell on Sheet A
='Sheet B'!A1 + 'Sheet B'!B1

The above will add cells A1 & B1 on Sheet B
Take special note of the apostrophies surrounding the sheet name.
Looking literally at your example, if you have a space in the sheet
name, you have to put apostrophies around it for Excel to recognize
it. If you don't have spaces, you don't need the apostrophies.
example:
If your sheets were named SheetA & SheetB then you could use
=SheetB!A1 + SheetB!B1

John
 
Back
Top