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

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.
 
S

ShaneDevenshire

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.
 
G

Gord Dibben

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
 

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

using the =page! feature to transpose a row to column 0
how do I tie multiple worksheets to one sheet in Excel? 1
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
Autopopulation of formulae after download of data into a master sh 3
sheet! functions 3
Transferring data from multiple sheets in workbook to one sheet 5
Sorting data from multiple worksheets into a master sheet/tab 5
Save record Into master sheet! 1

Top