Forum Discussion
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...
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)