Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text search and "Go To"...
I have a logistics Workbook with multiple worksheets. One worksheet is named:
Monthly Inventory. In column "D", I have the name of the product. At the top of the page I have a section of frozen panes that I keep for instant display for values. I'm looking for a solution to have a text box within my frozen pane to type the name of the product into and have excel scroll it to show it at the bottom of the frozen panes. I've searched the discussions and tried several formulas, A NO GO on my part. Is it possible to make this happen? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=IF(ISNUMBER(SEARCH("ELB", and more than one text | Excel Worksheet Functions | |||
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG" | Excel Worksheet Functions | |||
How do I search a worksheet for a custom "text" max and min value | Excel Discussion (Misc queries) | |||
=IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |