copy & paste question

[xoxo]

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...

 

[pgc01]

Hi

In Sheet2!A1:

=INDIRECT("Sheet1!A1")

 

[xoxo]

Hi

In Sheet2!A1:

=INDIRECT("Sheet1!A1")

Thank you very much, that worked beautifully.