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