Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Search in Excel
Hi,
I'm setting up a spreadsheet that includes mainly text information in topics, sub-topics and low level detail. eg. topic - telephony, sub-topic - IVR, low level - policy. How do I set up a search or LOOKUP function that will allow users to search for this (info on many different worksheets). I know it's probably not the best application to use but am stuck with using excel really so any help on how to set up would be great (as you can see I'm a novice!) -- Liz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Search in Excel
One way to find one item. For more that one find, look in the vba help index
for FINDNEXT Sub findtext() what = InputBox("Enter text to find") On Error Resume Next For Each ws In Worksheets Set c = ws.Cells.Find(what, LookIn:=xlValues, lookat:=xlWhole) If Not c Is Nothing Then ws.Select c.Select Exit For End If Next ws End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Liz" wrote in message ... Hi, I'm setting up a spreadsheet that includes mainly text information in topics, sub-topics and low level detail. eg. topic - telephony, sub-topic - IVR, low level - policy. How do I set up a search or LOOKUP function that will allow users to search for this (info on many different worksheets). I know it's probably not the best application to use but am stuck with using excel really so any help on how to set up would be great (as you can see I'm a novice!) -- Liz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
Using IF function in excel to search for text across cells and she | Excel Worksheet Functions | |||
How do I search a text string in many excel worksheets (files)? | Excel Worksheet Functions | |||
Search for Text in Excel | Excel Discussion (Misc queries) | |||
How do I search and replace text in a textbox in Excel? | Excel Discussion (Misc queries) |