Column A is sorted alpha numerically beginning in A3
A2 is the header
A1 is blank
TheData = dynamic named range, which is currently A2:T610
Panes frozen under the header row 2

I would like to begin typing into A1 and have TheData scroll based on what is being typed into A1.

So upon typing D into A1, the visible row under A2 becomes the first entry in column A beginning with D (possibly Row 32)

Then upon typing a second character, for example DE, the visible row under A2 becomes the first entry in column A beginning with DE (possibly Row 35)

Then upon typing a third character, for example DE3, the visible row under A2 becomes the first entry in column A beginning with DE3 (possibly Row 37)

and so on...

I don’t want to have to hit enter on A1 for this to happen, I want the scrolling to happen concurrent with the typing,
Because on hitting enter, I want to clear A1 and jump to the first visible cell under A2, which should be the data I’m looking for.

Is this possible?