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.


One way is to put this in A1:
=HYPERLINK(
"["&SUBSTITUTE(CELL("filename"),"[","")&"!A"&(8*COLUMN()-6),
CHAR(64+COLUMN()))
and then extend A1 to Z1.

The file has to be saved before the CELL function works.

(I have Excel 2003.)