Copy Exact Formula

  • Thread starter Thread starter bongiman
  • Start date Start date
B

bongiman

Hi,

I want to copy a range of formulae from one work book to another identicaly
formatted workbook but i do not wish the formulae to link back into the old
spreadsheet.

Both workbooks, Book1 & Book2 have a Volumes sheet and a Check sheet and
when i copy the formulae from Check on Book1 to Book 2, the fomulae still
point to the Volumes sheet on Book1 instead of the one on the same book.

What is the best way to do this?

The closest i've come is by using the following formula:
Sheets("New Check").Range("j4:p20").Formula =
Sheets("Check").Range("j4:p20").Formula

.....but this only copies formulae from one sheet to another within the same
book.

Please help!

Sheets("New Checksheet").Range("j4:p20").Formula =
Sheets("Checksheet").Range("j4:p20").Formula
 
bongiman said:
The closest i've come is by using the following formula:
Sheets("New Check").Range("j4:p20").Formula =
Sheets("Check").Range("j4:p20").Formula
Click to expand...

With both workbooks open in the same Excel instance:

Workbooks("Book2").Sheets("New Check").Range("j4:p20").Formula = _
Workbooks("Book1").Sheets("Check").Range("j4:p20").Formula


----- original message -----
 
Back
Top