Forum Discussion
a_j_birch
May 10, 2019Copper Contributor
Drag down formula for referencing sequential cells in another workbook
This may be really simple but I'm not great with Excel (yet!) I have a weekly total in one workbook which will appear every 7th row (H7, H14, H21, etc.). This needs to be referenced in another wo...
Twifoo
May 10, 2019Silver Contributor
Instead of entering =H7, =H14, and =H21 in D3, D4, and D5, respectively, you may use this formula in D3, copied down rows:
=INDEX(H:H,(ROW()-2)*7)
=INDEX(H:H,(ROW()-2)*7)