Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

I would like to move column 2 into column 1 for each successive sheet, one sheet per week, automatically. Is that possible? I do it with this formula ='1st week'!D2 and manually changing '1st week' to '2nd week', each week, but was wondering if it's possible to be done automatically. Thanks!

share|improve this question
Give us an example where you show what you have and what exactly you want – nixda Oct 8 '13 at 17:32
Is there a way to attach a spreadsheet here to show what I mean? Thanks! – Raquel Oct 8 '13 at 23:36
2 ways: Upload a screenshot at imgur and paste/edit the link to your question. A higher rep user will convert the link to a normal screenshot later. (Or) Upload your file at and again paste/edit the link – nixda Oct 9 '13 at 4:12

Your Answer


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

Browse other questions tagged or ask your own question.