Hi, I am encountering a problem where I get reference error when I move cells around. In my workbook, there are two sheets, and cells in the second sheet are referencing cells in the first sheet. For example, cells B2:D2 on sheet 2 reference cells H2:J2 on sheet 1. (the formula for cells B2 on sheet 2 is =Sheet1!H2) However, when I move cells H2:J2 on sheet 1 a row down to row 3, on sheet two the values for B2:D2 get updated but cells B3:D3 now have a reference error. I would like for cells B2:D2 to also move down to cells B3:D3, and for cells B2:D2 to appear blank like the cells H2:J2 are on sheet 1. Is there any way to do this, will I have to use vba?

A simpler of version of my question is: if I move cell A1 on sheet 1 to A2, how do I get cell A1 to also move to A2 and make A1 equal to the new blank A