Hi all.
In a cell, I have this link.
=[HPSI.xlsx]Sheet1!$J$31
In another cell, I wish to call data from [HPSI.xlsx]Sheet1!$J$31 +12 cells down (essentially, 43) but I want it in a formula to add 12 cells so that every subsequent time it will keep pulling data from down 12 more cells. How would I do that? If it's even possible.
Thank you
Bookmarks