CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS.
 

I have created a long list of supplies I have purchased for our company over
the past few years. It has become so long that I need an index. To easily
go to the products that I want to see, I would like to create a formula in a
third column that can be clicked on in the index and take me directly to the
title of the product title row. It will eliminate scrolling or using the
"find' feature.

CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS.
 

Maybe Data Filter Autofilter on the appropriate col would provide an
avenue?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Patty" wrote:
I have created a long list of supplies I have purchased for our company over
the past few years. It has become so long that I need an index. To easily
go to the products that I want to see, I would like to create a formula in a
third column that can be clicked on in the index and take me directly to the
title of the product title row. It will eliminate scrolling or using the
"find' feature.

CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS.
 

Try an alphabetic index. Say your products are in column A. In column C
enter:
=left(A1,1) and copy down. Then turn on AutoFilter. You can then select
any letter and see only the products starting with that letter.
--
Gary's Student
gsnu200708


"Patty" wrote:

I have created a long list of supplies I have purchased for our company over
the past few years. It has become so long that I need an index. To easily
go to the products that I want to see, I would like to create a formula in a
third column that can be clicked on in the index and take me directly to the
title of the product title row. It will eliminate scrolling or using the
"find' feature.

CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS.
 

Have you considered putting all the products starting with "A" on one sheet,
those starting with "B" on another etc. or, perhaps, using each sheet as a
category and grouping similar products on separate sheets

"Patty" wrote:

I have created a long list of supplies I have purchased for our company over
the past few years. It has become so long that I need an index. To easily
go to the products that I want to see, I would like to create a formula in a
third column that can be clicked on in the index and take me directly to the
title of the product title row. It will eliminate scrolling or using the
"find' feature.