Good Morning,
I'll give you a quick example of what I need to do. This is the only part of my spreadsheet that I cannot figure out. In row 8, I have consecutive hard numbers from 1 to 100, starting in cell C8 ... C8 has 1, D8 has 2, E8 has 3 and on until 100. In Cell A20, I have a simple formula of =C8 and 1 is the result in A20. I want to delete the entire column C and then the digit 2 (which was in D8) is now in C8. Now, I now want 2 to appear in A20 but I am getting an invalid cell reference #REF! because I moved a cell. Is there anyway around this so the formula =C8 always remains in A20? I will continue to delete columns and save the results as a new tab, so A20 will be a different value on each tab. Thanks for your help!
I'll give you a quick example of what I need to do. This is the only part of my spreadsheet that I cannot figure out. In row 8, I have consecutive hard numbers from 1 to 100, starting in cell C8 ... C8 has 1, D8 has 2, E8 has 3 and on until 100. In Cell A20, I have a simple formula of =C8 and 1 is the result in A20. I want to delete the entire column C and then the digit 2 (which was in D8) is now in C8. Now, I now want 2 to appear in A20 but I am getting an invalid cell reference #REF! because I moved a cell. Is there anyway around this so the formula =C8 always remains in A20? I will continue to delete columns and save the results as a new tab, so A20 will be a different value on each tab. Thanks for your help!