I have 2 sheets, sheet1 and sheet2. In sheet1 I have data that I will manually be moving up or down monthly. In sheet2 I need it to copy the contents of a specified cell. The problem is that when I move the row in sheet1 the information in sheet2 follows the cell. Ex. Sheet1 cell a1=x and cell a2=y. I need sheet2 to display sheet1!A1 even if I move a2 in its place.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Absolute referencing cell from another sheet
Similar threads
- Question
- Solved
