Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
I have strange requirement. I have a column with hundreds of entries in it. There is one other columns associated eith it. For an example consider that following are the entries in column A and B Column A Column B PI03590 bar ZT05693 % PIC098734 N TT09823 C Now I have to provide one userform input box to user. The user will enter entries separated by comma (or any other character). I have to filter entres in column B as per these inputs. e.g. If user enters (bar, N) in the input box, then macro should filter entries in column B and copy "unmatched" result to new sheet. In this case, Macro should copy following information in new sheet: ZT05693 % TT09823 C. (I do not want the user to manually filter it in the sheet as this needs to be incorporated in the already existing macro which performs several actions on the sheet.) Thank You in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
text string separated by comma | Excel Discussion (Misc queries) | |||
How can I extract the first & last name separated by a comma | Excel Discussion (Misc queries) | |||
Fixing Comma Separated Values (.csv) | Excel Discussion (Misc queries) | |||
Going from column to comma separated list... | Excel Discussion (Misc queries) | |||
CSV (Comma Separated Values) delimiter ? | Excel Programming |