Setting a formula parameter from an input box

[CuriousG]

I have a series of formulas in a workbook based on a Range with a fixed starting point A2 but the end of the Range can fluctuate depending on the dataset that is copied in for use. I figured I could get the Range end value from an input box but don’t know how to get this into the formulas automatically.

I’m guessing that if I was better at VBA I could probably dispense with the formulas embedded in the workbook and perform all the calculations in a VBA module. Sadly, this is beyond my level at the moment.

Any advice will be very gratefully received.