Hi Marc,
Repeating:
Please post a short example of the address range you
copied from, and the formulas by address.

It is impossible to guess what your problem is without a
description of the problem:
what you did, what formula you copied, from where to where,
what formula go got, and what you expected.
You have to show how the formula changed and what you expected.

Even if we tried to unravel your long paragraph, there are no
formulas -- you must provide a reproducible example of your
problem.

Example: -----------
A1: 2 B1: 4 C1=8 D1=ROW() E1: =SUM(A1:D1) displays 15

copy A1:E1 paste into A2, resulted in
A2: 2 B2: 4 C2=8 D2=ROW() E1: =SUM(A2:D2) displays 16

What I expected was: (describe what you wanted/expected)
-------------------
Are you familiar with relative and absolute addresses.
Relative And Absolute Addressing
.... formula containing a relative address, Excel will adjust the row and/or column
references ... This type of cell reference is called absolute addressing. ...
http://www.cpearson.com/excel/relative.htm

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