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!!