The sub will need to find its own data. Or you need a parent sub that asks
the user for the information.

It is common to select a cell or range before running the sub and have the
sub look at that.