Drag down formula for referencing sequential cells in another workbook

Copper Contributor

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 workbook in a column in sequential cells (D3, D4, D5, etc.).

 

Short of adding in a link for every cell is there a formula I can use to put in the first cell and drag down to populate subsequent cells?

 

Please and Thank You

1 Reply
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)