I have a cell with a formula in sheet1 which points to another worksheet cell
(sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but
Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I
tell it to just copy paste normally without excel changing my formula
targets?!

thanks!