| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same formula for each sheet?
I have an accounting spreadsheet set up where I can input my income and all
my expenses. I have four sheets set up, one for each quarter. I want each of the sheets to be exactly the same, but obviously the numbers for each quarter will be different. Is there a way to automatically update the formulas on each sheet based on the first sheet? In other words, if I change the formula in B5 on sheet one, I need it to update the formula for B5 on the other three sheets as well. -- www.myspace.com/twentysix_26 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| write formula that icludes data from sheet 1 to sheet 2 of my spr | Excel Worksheet Functions | |||
| Can I annotate a formula result in Sheet 1 in Sheet 2 by Cell Addr | Excel Worksheet Functions | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
Threaded Mode
