| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
| enter data in cell but cannot save until click off cell in excel | Excel Discussion (Misc queries) | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
| Click on cell-calendar drops down-click on date-date fills cell. . | Setting up and Configuration of Excel | |||
Linear Mode
