Home

Drag down formula for referencing sequential cells in another workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-558890%22%20slang%3D%22en-US%22%3EDrag%20down%20formula%20for%20referencing%20sequential%20cells%20in%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-558890%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20may%20be%20really%20simple%20but%20I'm%20not%20great%20with%20Excel%20(yet!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20weekly%20total%20in%20one%20workbook%20which%20will%20appear%20every%207th%20row%20(H7%2C%20H14%2C%20H21%2C%20etc.).%20This%20needs%20to%20be%20referenced%20in%20another%20workbook%20in%20a%20column%20in%20sequential%20cells%20(D3%2C%20D4%2C%20D5%2C%20etc.).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShort%20of%20adding%20in%20a%20link%20for%20every%20cell%20is%20there%20a%20formula%20I%20can%20use%20to%20put%20in%20the%20first%20cell%20and%20drag%20down%20to%20populate%20subsequent%20cells%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20and%20Thank%20You%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-558890%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-560310%22%20slang%3D%22en-US%22%3ERe%3A%20Drag%20down%20formula%20for%20referencing%20sequential%20cells%20in%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560310%22%20slang%3D%22en-US%22%3EInstead%20of%20entering%20%3DH7%2C%20%3DH14%2C%20and%20%3DH21%20in%20D3%2C%20D4%2C%20and%20D5%2C%20respectively%2C%20you%20may%20use%20this%20formula%20in%20D3%2C%20copied%20down%20rows%3A%3CBR%20%2F%3E%3DINDEX(H%3AH%2C(ROW()-2)*7)%3C%2FLINGO-BODY%3E
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)