I seems like you need to set parts of your references to be Absolute, instead
of Relative.

In a formula, a dollar sign ($) locks in that part of the reference.

Examples:
A1: =$C3

When copied and pasted elsewhere in the worksheet, that formula will ALWAYS
reference Col_C, but the referenced row will change.

A1: =$C$3
will always reference cell C3 no matter where it is pasted.

For more information, search Excel help for "range references" and read the
section on:
"The difference between relative and absolute references"

Does that help?

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

XL2002, WinXP-Pro


"cgs" wrote:

How do I cut and paste formulas and resultents with out EXCEL increasing the
cell number ?