Building a workbook. Mostly copy & paste data but some calculations. Yesterday I enter a calculation in cell C2 and click the little box to copy the formula all the way down the page. Everything working great. Today I do the same thing and the results from C2 are displayed on every row despite each cell having a different formula.
Example
Yesterday
C2 = A2+B2 cell displays 3881
C3 = A3+B3 cell displays 2424
C4 = A4+B4 cell displays 1423
C5 = A5+B5 cell displays 1885
Today
C2 = A2+B2 cell displays 3881
C3 = A3+B3 cell displays 3881
C4 = A4+B4 cell displays 3881
C5 = A5+B5 cell displays 3881
Data in columns A & B not changed at all. If I manually type the formula in each cell it calculates correctly.
Example
Yesterday
C2 = A2+B2 cell displays 3881
C3 = A3+B3 cell displays 2424
C4 = A4+B4 cell displays 1423
C5 = A5+B5 cell displays 1885
Today
C2 = A2+B2 cell displays 3881
C3 = A3+B3 cell displays 3881
C4 = A4+B4 cell displays 3881
C5 = A5+B5 cell displays 3881
Data in columns A & B not changed at all. If I manually type the formula in each cell it calculates correctly.