I am using excel to help me generate some SQL queries. I have a cell which generates the queries, then another 3 cells which stores a user id, first name, and last name. I also have cells which store a date and time, which is unique for each user. Basically, what I need to do is move around the user data (id and name) depending on their ranking. Now, when I copy one user, and swap them with another user, the formulas still reference the original data. Example, the formula in C1 should always reference the user id in C2, but if I switch C2 and D2 by copy/pasting, C1 will reference D2, and D1 will reference C2. The only solution I have found so far is to do all my moving around, then re-drag the formula to overwrite everything. Is there a way to make C1 always reference C2, no matter what, even if I copy/paste the data elsewhere?

Thanks!

Joe