Home

Drag down formula for referencing sequential cells in another workbook

a_j_birch
Occasional Visitor

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)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies