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"
