Forum Discussion
Copying from one Sheet to another
I know I can link two cells on different sheets by referencing on Sheet 2 (=Sheet1!B1). My problem is I would like to be able to drag and drop cells on sheet 1 to change the order. But when I do I get a #Ref error on Sheet 2. Is there a way around this?
- I've tried the scenario your saying, but no such error message popped up,
the only change is in Sheet2 - where the cell address is changed to the dropped position..
maybe there is some other links or formula involved.
