VBA worksheet change to scroll down to specific text

[emacjake]

Hi All

I'm reasonalby fluent in excel but my vba knowledge is limited.

I'm looking for some help with a code to scroll down to a specific title when a selection is made from a drop down list at the top of the page?

looking to save a lot of scrolling and ctrl F time

please help

Cheers!

 

[My Aswer Is This]

We need details.
1. What cell is the drop down list in?
2. And if you choose Sue from the drop down list where is Sue

 

[emacjake]

so in cell L4 is the drop down list with name of the outlet

and in Column B is the list, with the outlet name followed by list of all products sold in that outlet then the next outlet name and all prodcuts sold and so on, with 12 outlets this list is more than 2000 rows long

Thanks!

 

[My Aswer Is This]

Try this:

To install this code:

Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste this code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("L4")) Is Nothing Then
        If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
    With Range("B:B")
        .Find(Cells(4, 12).Value, LookIn:=xlValues, lookat:=xlWhole).Select
    End With
    End If
End Sub

 

[emacjake]

You are a LORD!

Works perfect!

Thanks so much for you help!

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

You are a LORD!

Works perfect!

Thanks so much for you help!

 

[emacjake]

Thanks again

I'm looking to get a little more well rounded in the VBA language, is there anyting online you could suggest to learn some more of the basics, so far it's just been youtube and this forum,

I've learned some very helpfull macro's, and have a basic understanding on how to record and edit simple ones. but would like to know a little more about how they work and how to write them

Cheers

 

[My Aswer Is This]

You may find some useful resources here:
MrExcel.com | Excel Resources | Excel Seminars | Excel Products