I'm referencing a cell from another worksheet. I'm using =worksheet1!C2 but I have to rearrange the columns in worksheet 1 which would result C2 moving to A2. How would I then get it to automaitcally follow the data in C2 when it gets rearranged to A2?
Bookmarks