COPY FORMULA

[JAMESSINC]

I have several spreadsheets that are all exactly the same
and I want to copy formula's from a master spreadsheet to
the other spread sheets without having the formula link
to the master spread sheet. How do I do this.

 

[JulieD]

Hi

if i'm understanding you correctly the following should work (but as always,
ensure you have a backup!)
oh, and this puts the formula in the same cell on each sheet that it was in
on the master (IYKWIM)

select the cell with the formula you want to copy to the other sheets
click on the sheet tab of the first sheet you want to copy it to,
hold down your shift key and click on the sheet tab of the last sheet you
want to copy it to,
all sheet tabs between these two should go white (the master sheet will also
be white - that's okay)
now choose
edit / fill / across worksheets and click OK
click on the other sheets to check.

let us know how you go.
Cheers
JulieD