SUNSHINE2400
New member
- Joined
- Aug 18, 2015
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Hello,
I am new to posting on a forum...I have run out of steam trying to produce a new worksheet. There is a Daily tab and a Weekly tab. The weekly references the daily information. The formula I created references every 22nd row, but when I click and drag the formulas, it does not recognize the pattern.
Formula:
=INDEX(DAILY!$D$1:$D$458,(ROWS($F$5:F5)-1)*$Q$3+$Q$2)
=INDEX(DAILY!$G$1:$G$458,(ROWS($F$6:F6)-1)*$Q$3+$Q$2)
=INDEX(DAILY!$J$1:$J$458,(ROWS($F$7:F7)-1)*$Q$3+$Q$2)
Q3 is the increment by 22 and Q2 is the starting line number 18
It pulls the data from the daily sheet properly for the first week, but when I click and drag down (to create each week of the year) F5 gets changed to the actual cell the formula is in. If I change =INDEX(DAILY!$D$1:$D$458,(ROWS($F$5:F5)-1)*$Q$3+$Q$2) to =INDEX(DAILY!$D$1:$D$458,(ROWS($F$5:F6)-1)*$Q$3+$Q$2) the next weeks data is properly populated. But when I click and drag it automatically gets changed to =INDEX(DAILY!$D$1:$D$458,(ROWS($F$5:F36)-1)*$Q$3+$Q$2) and I get an error message.
I can attach a copy if need be since this is difficult to explain in writing.
Thank you for any input!
I am new to posting on a forum...I have run out of steam trying to produce a new worksheet. There is a Daily tab and a Weekly tab. The weekly references the daily information. The formula I created references every 22nd row, but when I click and drag the formulas, it does not recognize the pattern.
Formula:
=INDEX(DAILY!$D$1:$D$458,(ROWS($F$5:F5)-1)*$Q$3+$Q$2)
=INDEX(DAILY!$G$1:$G$458,(ROWS($F$6:F6)-1)*$Q$3+$Q$2)
=INDEX(DAILY!$J$1:$J$458,(ROWS($F$7:F7)-1)*$Q$3+$Q$2)
Q3 is the increment by 22 and Q2 is the starting line number 18
It pulls the data from the daily sheet properly for the first week, but when I click and drag down (to create each week of the year) F5 gets changed to the actual cell the formula is in. If I change =INDEX(DAILY!$D$1:$D$458,(ROWS($F$5:F5)-1)*$Q$3+$Q$2) to =INDEX(DAILY!$D$1:$D$458,(ROWS($F$5:F6)-1)*$Q$3+$Q$2) the next weeks data is properly populated. But when I click and drag it automatically gets changed to =INDEX(DAILY!$D$1:$D$458,(ROWS($F$5:F36)-1)*$Q$3+$Q$2) and I get an error message.
I can attach a copy if need be since this is difficult to explain in writing.
Thank you for any input!