If you give an example of your formula and describe what goes wrong when you
copy it you'll increase your chances of getting a specific solution.

Meanwhile, look for this in Excel Help:
"about cell and range references"
and check the section on "The difference between relative and absolute
references"

Does that help?

***********
Regards,
Ron


"excel worksheet" wrote:

I need to insert more lines in my database but I don't know how to copy down
the formula so it stays the same. Thank you.