E:F

A10:B12

A10:B

1:5

A:A6

C5:5

The Inputbox onKeyUp event will change Global Var rng for Range.

Click to load Input Range...