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

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

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.

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.

Same formula for each sheet?
 

VBA event code.


Gord

On Mon, 23 Jun 2008 14:45:01 -0700, Jeremiah
wrote:

Is there another method?