Generally speaking if select ALL sheets by right clicking any sheet tab and
selecting all sheets and then change something on one sheet excel will
change all others also. Easy enough?

--
Don Guillett
SalesAid Software

"Graham" wrote in message
...
I have a large workbook of some 50 worksheets.This workbook is used to
mailmerge to Word to produce various documents, so is also set up as a
data
source. Each sheet has a large number of calculations in various columns.
As
I find that I need to amend existing formulae and/or add additional
columns
at times:
Is there a simple way of amending, say Column 1, Worksheet 1, and this
automatically updating Column 1 in all the other sheets - WITHOUT messing
up
any of the important data. I have been doing this by copying my amendments
and then pasting to each succesive sheet, but this is now becoming
unmanageable due to the number of sheets. Best advice please - You've been
very helpful in the past!!