View Single Post
 
Old 04-19-2009, 02:43 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Quote:
Originally Posted by freelance_jhoe26 View Post
as you can see there is another sheet named summary...

what i need to do is once i updated an amount in expense company... that update also must reflect on the other sheet named summary...
Then follow the instructions - any time the Expenses sheet changes, so will the Summary!!

Quote:
The file you uploaded requires a formula in SHEET Expenses, CELL B6 that will show the total in SHEET Expenses in Company, CELL B11!

If that is all you are looking for then the answer is:

Code:
='Expenses in Company'!B11

To make this, you would click on SHEET Expenses, CELL B6 and do the following:

  • Make sure the cell is the active one
  • Type '=' (without the apostrophes)
  • Click on the 'Expenses in Company' tab
  • Click on CELL B11
  • Press enter
Reply With Quote