Replicating Formulas

[Voodoodan]

Hi,

I have a worksheet that has been copied many times in the sam
workbook.

In each worksheet is a formula: =A1:G1, that reflects that particula
worksheet's data.

This needs to be changed every month to reflect an additional month'
data, so this may change to: =A1:H1.

However, the thought of wading through endless sheets and changing th
same formula for each worksheet scares me!

Is there any way I can manually change the formula in the firs
worksheet, and then for the same formula to automatically be amended i
all the other sheets?

Thanks,
Dan

 

[DavidP]

Select all the sheets that you wish to update, Various ways to do
this. I assume you want all sheets so rightclick any tab and click
"select all sheets". Amend anything you want including formats and
the changes will be replicated on every selected sheet

DavidP

 

[Voodoodan]

It works just as I wanted.

Thanks very much David.

Dan