I have a workbook with 2 worksheets.
Worksheet #1 contains a range of values that I need to use for calculations in worksheet #2.
The range runs from A1:A10.
Is it possible to use a formula that can identify these start and end values without me having to explicitly hard-code them? Additionally, I'd like Excel to name the range once it locates it, so that I can use the name as an input parameter for a subsequent SUMPRODUCT() function.
I'm trying to avoid using VBA, but not sure if what I am trying to do is possible with off-the-shelf formulas.