I want to add two cells on worksheet 1 to sum in a cell on worksheet 2 in the
same workbook. Then I want to copy that formula down a few cells on whsht 2
letting the columns change and the row remain static. However, when I copy
down the formula it changes the rows and keeps the column. If I anchor the
row, it copies the exact formula changing nothing. I need an answer in a
hurry!