Hi, I am able to copy one cell to the next cell with the equal sign (=), but when I added new rows/columns the cell is locking on to the cell I wanted to copy. How can I have it copy the spot but not the cell?
Like if I have info on sheet1, A1 and I wanted to copy the same info on Sheet2, A1 and place it there regardless if the row/column changed on sheet1. If sheet1, A1 info moved to sheet1, A2 I still want the sheet2, A1 to hold the spot of sheet1, A1.
Hope that make sense...
Like if I have info on sheet1, A1 and I wanted to copy the same info on Sheet2, A1 and place it there regardless if the row/column changed on sheet1. If sheet1, A1 info moved to sheet1, A2 I still want the sheet2, A1 to hold the spot of sheet1, A1.
Hope that make sense...