I have a marco which moves data onto separate sheets within a workbook. On 1
sheet is a summary of the sheets which uses a number of "countif" and Sum
functions.

What the macro does (and i don't want it to) is make the cell reference -
$a$2 change to $a$3 every time the macro adds a new row on one of the other
sheets. What can be done to prevent this from happening?

Regards

Richard