I have a formula in a column in cell B2 that looks at cell D2 in another workbook and in cell B3 I want it to look down 8 rows to D10 then in B4 I want it to look down another 8 rows to D18 etc. Is there a way to do this? I tried using the fill option and a few other things with no luck.
Thanks
Thanks