how do you tie in balances into 1 master sheet on excel

  • Thread starter Thread starter traci
  • Start date Start date
T

traci

in excel, I have various sheets with balances. How do I create a formula
that will tie the various sheets into one master sheet instead of having to
go back and forth bewteen my master sheet and individuals sheets repeating
the formula for each individual sheet.
 
Hi,

1. The easiest way is to move to the Master sheet, select a cell where you
want the data from one sheet to appear
2. Type =
3. Click on the sheet tab that your data is in , then click on the cell you
want and press Enter.
 
Are the balances on each sheet in the same cell?

=SUM(Sheet2:Sheet12!F34) entered in a cell on Sheet1


Gord Dibben MS Excel MVP
 
Back
Top