I am having a problem with the cell refrence changing in my formula when I click and drag information. example - formula is in cell H4, and refers to info in C4, D4, E4 & F4. When I highlight C4, D4, E4 & F4 and click and drag to a new row the formula changes and follows it to its new position. Example - if I move the info to row 6, the formula in cell H4 now refrences the info I moved to row 6...I am holding the column refrences constant.
Please help!
Thanks.
Please help!
Thanks.