Quote:
Originally Posted by freelance_jhoe26
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
|
04-19-2009, 02:43 AM
Similar Threads
Office 2007
Threaded Mode