Hello, does anyone know how to advance a formula sequentially every three rows in excel? I just want the last cell reference to increase every three rows. When I fill down it skips sequential numbers.
Here is an example of the formulas I am using in column A:
Row1='[CCData 4.14.21 Master.xlsx]AA'!$AM1
Row2='[CCData 4.14.21 Master.xlsx]AA'!$AO1
Row3='[CCData 4.14.21 Master.xlsx]AA'!$AP1
Row4='[CCData 4.14.21 Master.xlsx]AA!$AM2
Row5='[CCData 4.14.21 Master.xlsx]AA'!$AO2
Row6='[CCData 4.14.21 Master.xlsx]AA'!$AP2
Thank you!
Bookmarks