| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for a string in another sheet
Hello everybody
My workbook contains two worksheets named "school and Rct". The school sheet contains "No and Name" heads in column B and C. I want to search all (like Ctrl F & findall in excel) for a string in "shcool!Name column" from Rct sheet . I want the search box to have two columns No and Name; and list all the names that contain the search string and place the selected No value in rct!activecell. I would like to search from Rct!sheet only. I don't want to display School!sheet. Is it possible with the VB code? Thank you all in advance. With regards Sreedhar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wildcard search for string within a string? | Excel Programming | |||
| How to macro: 1.Search for string - 2.Copy row - 3.Paste in new sheet | Excel Programming | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| search a string withing a string : find / search hangs | Excel Programming | |||
| Use sheet name as search string or autofilter criteria | Excel Programming | |||
Hybrid Mode
