Thread: how do you tie in balances into 1 master sheet on excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do you tie in balances into 1 master sheet on excel
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

On Mon, 29 Sep 2008 14:05:01 -0700, traci
wrote:

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.

Reply With QuoteReply With Quote