Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Rows in a spreadsheet
I have a large spreadsheet with multiple columns and many rows. One ro
is product Name, another column is Product Description. Can I searc each row in this sheet by using two terms, for example, "IBM" fo Product Name and "Desktop PC" for Product Description. Also, i general, can the search term include a wild card??? As always, thanks for all the help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Rows in a spreadsheet
Using the find method
You can search for IBM, then check if the description cell contains Desktop PC. If so, you found it. If not, continue the search (Find Next). See the help example for FindNext. Yes, you can use some wildcards in the argument to the Find Method. What:="ABC*", Lookat:=xlWhole will find cells that start with ABC for example. -- Regards, Tom Ogilvy "QandA " wrote in message ... I have a large spreadsheet with multiple columns and many rows. One row is product Name, another column is Product Description. Can I search each row in this sheet by using two terms, for example, "IBM" for Product Name and "Desktop PC" for Product Description. Also, in general, can the search term include a wild card??? As always, thanks for all the help. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Rows in a spreadsheet
Thanks Tom...
My main question, can you search the rows of the sheet using two term at the "same time"? I would like to do a search in one time and labe the row where the search is successful for the two terms and not jus one at a time -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Rows in a spreadsheet
No. But since you achieve the expected results with the method I provided,
I don't see the difference. An alternative would be to use the Autofilter to filter each column on the respective value, then pick up the visible row (if any). You can do this manually with the macro recorder on to get the code. -- Regards, Tom Ogilvy "QandA " wrote in message ... Thanks Tom... My main question, can you search the rows of the sheet using two terms at the "same time"? I would like to do a search in one time and label the row where the search is successful for the two terms and not just one at a time. --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Rows in a spreadsheet
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding a search box to a spreadsheet | Excel Worksheet Functions | |||
How can you search by column or row within a spreadsheet? | Excel Worksheet Functions | |||
Search for TRUE in spreadsheet | Excel Discussion (Misc queries) | |||
Search Spreadsheet for a name | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) |