I've tried it several ways. I'm creating a work book to generate quotes. I
enter everything on the first page and it fills the good, better, best
sheets which than fill three printable quotes on the same sheet. So once I
got the sheets set I figured I could just C&P the formulas and use
find/replace to make the changes. I've tried clicking the upper left square
so it high lights the entire sheet and than C&P to the other two sheets
using "paste special" - formulas and all - but got the same results as if I
just pasted regular. I've tried copying "B11:T11" and pasting to B34:T34,
"B56:T56" and "B78:T78" on one sheet and copying "AP15:25" pasting to
"AP59:69", "AP103:113 on another and copying "AB4:AR44" and pasting to
"AB48:AR88" and :AB92:AR132. The simple formulas either linking to another
cell or adding or multpling by 2 cells are OK but anything more complex gets
trashed and I used "paste special" formulas which I thought would make a
"carbon copy".

Marc

David McRitchie" wrote in message
...
Hi Marc,
Please post a short example of the address range you
copied from, and the formulas by address,
Next the address range you are pasting to and the formulas
you got -- and the formulas you expected.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Marc" wrote in message
link.net...
Actually it's with copy and paste! If I copy a series of cells that I
have
formulas in to use in another place when I paste the simple formulas are
OK
but the more complex ones get trashed. It happens if I copy and paste
as
you normally would and if I use special just "formulas". I've tried
"all"
and the same thing happens. What am I doing wrong. What should have
taken
a few hours has taken me all day to do cell by cell.

Marc

P.S. this is the reason for the rant!