| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Same formula for each sheet?
Select all sheets, then make ur changes
"Jeremiah" skrev: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Same formula for each sheet?
One method...........
Select all 4 sheets prior to editing B5 on the active sheet. Changes will be done to all sheets. DO NOT FORGET to ungroup the sheets when complete. Gord Dibben MS Excel MVP On Thu, 19 Jun 2008 17:38:00 -0700, Jeremiah wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Same formula for each sheet?
Is there another method?
-- www.myspace.com/twentysix_26 "Gord Dibben" wrote: One method........... Select all 4 sheets prior to editing B5 on the active sheet. Changes will be done to all sheets. DO NOT FORGET to ungroup the sheets when complete. Gord Dibben MS Excel MVP On Thu, 19 Jun 2008 17:38:00 -0700, Jeremiah wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Same formula for each sheet?
VBA event code.
Gord On Mon, 23 Jun 2008 14:45:01 -0700, Jeremiah wrote: Is there another method? |
| Reply |
| 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 | |||
Hybrid Mode
