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"
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.