Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go to cell - Query
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Single Cell Web Query | Excel Discussion (Misc queries) | |||
Web Query for a Single Cell | Excel Discussion (Misc queries) | |||
Query on Cell | Excel Discussion (Misc queries) | |||
unprotect query cell | Excel Worksheet Functions | |||
Query about Last Cell reference. | Excel Discussion (Misc queries) |