Filtering rows in a column based on a string value search in excel worksheet.

[Lifeseeker]

Hi there,

I would like find a way to perform searching in Excel 2010 with the aid of VBA.

How it should work:

1) users will click on the "locate" box to bring up a search box
2) system passes whatever strings user specifies in the box to the spreadsheet and it will then filter column A based on the value specified.
3) system will then help users locate the rows where that searched string is stored. (it can be more than one rows returned)

Is this possible?

I have the following partial coding in there, but am stuck as to how to build in this input box and the code for filtering..

Please Login or Register  to view this content.

Any ideas?

[arlu1201]

system passes whatever strings user specifies in the box to the spreadsheet and it will then filter column A based on the value specified.

Column A on which sheet? Irrespective of the sheet, there is just "K" in column A of both sheets.

[Lifeseeker]

Column A on which sheet? Irrespective of the sheet, there is just "K" in column A of both sheets.

Hi Arlu,

Sorry I wasn't being clear.

I have re-attached the file.

so users will search in column B by invoking in that button, and because the relationship between values in col A and B are many to many, I would like Excel to filter rows that contain the string being searched for.(so for example, if we are searching for "K95300001", then only two entries should appear because that K string is contained in two rows.)

Also, is it possible that the search is NOT exact match? I find that users just type in some strings and as long as they match the actual string, it is fine.

Does this make sense?

Thanks

[arlu1201]

So for this question that you have, sheet 1 and sheet 2 are not related at all right? We do not need to use sheet 2, right?

[Lifeseeker]

So for this question that you have, sheet 1 and sheet 2 are not related at all right? We do not need to use sheet 2, right?

No, just sheet1 please.

Thanks

[arlu1201]

Use this code -

Please Login or Register  to view this content.

[Lifeseeker]

Hi Arlu,

If user searches a string in column B, can he do so?

I have tried to put in a string that is found in col B in the inputbox, but Excel just kind of filers the entire page out wihtout showing me any row.

Searching on col A works,and it is amazing to have just these few lines to do what I would like to do!

Thanks

[Lifeseeker]

oh nvm, I think I got it.

I changed the range to be filtered on. lol