Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I know how to reference a cell in another sheet in Excel, but I'd like to know if there's some way to automate this process, such that if I duplicate a sheet, it will update its references to the previous sheet in sequence.

For example, let's say sheet n has a cell that references a cell in sheet n-1. If I have sheets 1, 2, and 3, I want the cell in 3 to reference a cell in 2. Then, if I duplicate 3 (making Sheet 4), I want the same cell in 4 to reference the cell in 3.

Ordinarily, I'd have the cell in sheet 3 read, 'Sheet2'!A1. Then, if I duplicate Sheet3 to make Sheet4, I'd have to go into that same cell on Sheet4 and change it from 'Sheet2'!A1 to 'Sheet3'!A1. I'd rather have this change done automatically when I duplicate the sheet.

Sorry for the long-winded explanation, but is there a way to automate this process rather than having to do it by hand? I'm currently using Excel 2013 preview but I also have Excel 2012.

Thank you!

share|improve this question
    
Nevermind, found my solution right here: j-walk.com/ss/excel/tips/tip63.htm . Turns out macros are extremely powerful! :) –  Argus9 Dec 26 '12 at 2:53
1  
Perhaps you can answer your own question, so that the rest of the world can benifit as well!! –  Jacob Jan Tuinstra Dec 26 '12 at 5:27
    
I did, check my comment above. –  Argus9 Dec 26 '12 at 19:06
1  
You've answered it as a comment. If you answer it as an answer, people tend to notice it better and can benefit from it. –  Jacob Jan Tuinstra Dec 26 '12 at 19:14
    
Ah, I gotcha. Thanks for the tip! –  Argus9 Dec 26 '12 at 19:48

1 Answer 1

up vote 1 down vote accepted

I found my solution right here: j-walk.com/ss/excel/tips/tip63.htm . Turns out macros are extremely powerful! :)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.