Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I update (using VBA) a formula referencing a cell in column X on one spreadsheet when copying that row to another spreadsheet in the same workbook, but moving that particular cell to a different column, Y? Initially it was done automatically, but some undetermined action caused the link to break (I hope I got the terminology right)...

Thank you!

share|improve this question
try to use a real-world example to clarify what you're asking, because to me this question is a little bit unclear – Raystafarian Mar 16 '12 at 21:50
What was the formula you copied? What cell was it in? Where did you copy it TO what did it change TO when you copied it. What SHOULD it have been, your preference? – Jerry Beaucaire Mar 16 '12 at 22:18
On the first sheet it looks like this: =(Y31*Sheet2!$J$205+...+BR31*Sheet2!$N$205), when copied (by VBA application) to the third sheet, value in BR column is moved to BY. Prior to the "undetermined action" Excel used BY value to calculate the total on the third sheet, now it still uses BR. – ayzik Mar 16 '12 at 23:20

You must log in to answer this question.

Browse other questions tagged .