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 would like to make a formula that can be fill copied to the next line progressing from one worksheet to the next. We have a worksheet for each day of the week that is identical in set up and would like Sheet 1 to be the summary specific data in each sheet. So for Row 1 it would be =Sheet2!$A$1 for Row 2 it would be =Sheet3!$A$1. Is it possible to use the fill to accomplish the change from Sheet2 to Sheet3? Thank you for your help.

share|improve this question
    
It's probably not possible, as Sheets don't need to have sequential names. But in your case, the changes you would have to make would be trivial, just alter the first instance of the cell in each row. Afterwards the fill copy algorithm doesn't mess with the sheet. –  Doktoro Reichard Oct 14 '13 at 20:36

1 Answer 1

Assuming you don't have any header rows, and your summary data starts on row 1, and sheet2 is the very first sheet with the first day's data, you could do something like this on sheet 1:

=INDIRECT("'Sheet"&ROW()+1&"'!$A$1")

This builds the sheet name reference based on the current row index + 1.

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.