Originally Posted by
John521520
My Requirement:
I want to link Ranges of these 5 formulas with cells B4 and C4 (Cell B4 and C4 make basically a series staring and ending values)
Now whenever I have to find these five values for a specific range, I would only put required series starting and ending values in cells B4 and C4 respectively)
Try
vba
Or just
1)Select G4:L4
2) Ctrl + H (find + Replace) replace E4:E10 with OFFSET(INDIRECT("e"&$B$4&":e"&$C$4),,,$C$4-$B$4+1)
Then the formula should work as you change any one of B4:C4.
Bookmarks