Jump to Cell Based on Forula Value

[WTFCIVILENG]

Trying to create a jump button as have a very long lis of values. want to be able to enter a value in cell D, then the cell selected jump down to where it is in the list. So if i put in 1.04, the cursor or selected cell jumps down to C8, if I put in D1 vlaue 1.10, it jumps down to C20 where it lists 1.10, if if put 2.20, if jumps down to cell C220. Want to create the VBS code and then attach it to an image.

 

[Burrgogi]

.... if if put 2.20, if jumps down to cell C220. Want to create the VBS code and then attach it to an image.

WIll that value always be contained in cell C220? What happens if the list gets updated and things get shifted around? The better option would be create a search box that users can type into (2.20 for example) and then jump to the cell containing the value. You can achieve this with a ActiveX control search box.

Here are some examples:

Create a search box in Excel – A step-by-step guide

www.extendoffice.com

How to Create a Search Box in Excel (4 Easy Methods) - ExcelDemy

How to create a Search Box in Excel is shown by using four distinct methods including- Conditional Formatting, FILTER Function etc.

www.exceldemy.com

Dynamic Data Search Box in Excel (with FILTER)

Learn how to build a dynamic data search box in Excel that allows you to filter your data as you type (using the new FILTER function in Excel 365).

excelfind.com

 

[WTFCIVILENG]

the location of the cell will shift but the text or value will remain constant. will try the search box now.

 

[WTFCIVILENG]

That is really handy to see what you have entered for that cell value, but need to jump down to row 220 to enter the data. I've used =MATCH(B6,C:C,0) to figure out the row number for the specific text (this formula will always remain in the same spot, but now ned to create a method to jump down to that row. Bear in mnd that the row the text in will change depending on data input. so thought if there is a way to create a vba code to jump to that row based on the formula input?

 

[WTFCIVILENG]

Screenshot is the excel sheet. basically song names 1.01 up to 1.99 is in clumn C. Column A orks out the row the first time 1.01, 1.02, 1.03 etc. is listed