Multisheet formula autofill while skipping rows

[SimTurner]

Hello all-

I am struggling to figure out what is likely a simple problem.

I have a workbook in which I keep track of daily numbers on one worksheet, however, I compile reports for those numbers in a separate worksheet which only needs to reference 1 day per week. I created a formula to that points at the first day I need to reference, and I would like to autofill the formula into the subsequent rows on the worksheet, but need to skip rows.

Here's an example of the formula I created in the worksheet titled "weekly report":

Cell C5: ='DailyNumbers!P5'

I need cell C6 on the weekly report worksheet to say ='DailyNumbers!P10', and then cell C7 to say ='DailyNumbers!P15' etc etc etc for many hundreds of rows. Of course, when I try to autofill the formula, however, the relative referencing just makes the cell reference 1 row higher each time.

Is there a way for me to force autofill to skip rows so I can quickly create all of the formulas I need, or am I looking at hours of formula typing to get it all plugged in?

Thanks in advance!

[protonLeah]

Not knowing the layout of your sheets, try this:
On the Weekly Report sheet, select an unused column (X, for example) and, in row one enter,

Please Login or Register  to view this content.

Copy down as needed. Then in cell C5 replace the current formula with:

Please Login or Register  to view this content.

and copy down.

[SimTurner]

Great! Thank you very much!

[germantownclark]

Hi i'm trying to do the same thing here, where the i want to skip 57 rows using autofill, but somehow i can't get it to work,

[ace_1321]

I also can't get the above formula to work. I've attached my sheet with the errors I'm getting. Hopefully we can figure this out. Thanks for the help.

[arlu1201]

Ace_1321,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

[tommyhhart]

Hello Forum Guru,

I hope this message finds you well. I had a similar issue to this person, and tried entering my data, relevant to your formula, but received an error message. Your formula listed above is: ='DailyNumbers!P & ROW() * 5. There is an extra single quote mark, so I did edit that, but what value do I put into the ROW() variable? The row # from the reference sheet?

Any input is appreciated,
T