Vba Jump to cell

[charly1]

Hi all.

This is like my third question in the last day or two. I feel like I've struck gold with this forum, you guys have already helped me with countless future work saving hours.

Anyways here is my question,

I have a table with a couple thousand lines of data, Is there an easy way to have a kind of text box at the top of the spreadsheet and as i type a data into that box, the active cell would automatically jump down to the first matching cell. I've found online some code for something like that, however that only allows entering a single letter and matching it to the first letter of the table cells. The problem though for me though is that many hundreds of the data cells begin with the same letter [i.e names of people that all begin with Mr].

As an extra, It would be amazing if i would be able to specify which column should be searched for the corresponding data in the text box, thereby allowing me to jump easily to any cell in the table with column specification.

Thanks a lot to all of you, for giving of your time.

 

[charly1]

Hi

I've actually managed to find a solution alone [believe it or not!].

=HYPERLINK("#"&"Sheet1!E"&(XMATCH(I1,BOOK)+3),"Hello")

A dynamic hyperlink formula in which the cell row number in the link location, is actually a nested xmatch formula, returning the row number of the matching data selected in an adjacent drop down list that contains all of the data displayed column A