Function cannot perform actions. Therefore, you are unable to select another
cell with a function. This would need to be done with a macro.
I would suggest you so a worksheet change event and have the end-user update
a cell with the value the want to see. It would look something like this.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("a1") Then
Select Case Target.Value
Case "A"
Range("a7").Select
Case "B"
Range("a14").Select
Case Else
Range("A21").Select
End Select
End If
End Sub


"Bill" wrote:

Hi,

I have a work sheet that lists produts in alphabetical order.

The top of my work sheet displays the alphabet and each letter has a cell.

Under this row the letter A is and it has 7 blank rows under it - to display
products beginning with the letter A and then the letter B is on the next row
and this has 7 blank rows underneath it and it will store products beginning
with B etc.

Can a function be set up to do the following. When I select a letter from
the alphabet on the top row say P, the page automatically goes to my list of
products beginning with P.

If possible I would prefer not to use macros.

Any help would be much appreciated.

Thanking you in advance,

Bill


Hello Bill,

Function can not proform actions.