Text Filter-begin With... (multiple Begin Withs?)

Hi, Hari,

Column D in the attached workbook is showing a Name (here John Doe), and obviously there canīt be done any filtering on a name regarding a number. And the contents looks very familiar to me but from a different user as well a different posting

Ciao,
Holger

Hi, Hari,

the code will always work on the active sheet:

Please Login or Register  to view this content.

Ciao,
Holger

Dear Holger,

Getting error message as : Run time error :13

Type mismatch

If the data begins with "4500, 6500, 1032, 8000, 6000, 8500, 1000, 9320, 7000, 7500" than only it should come as "YES"

Please check and revert me back please

Regards,
Hari

Hi, Hari,

code was developed and tested on your sample with Excel2007, downloaded the file again, inserted the code in a module, hit F5, no RunTimeError with 2007.

Ciao,
Holger

Dear Holger,

Agian the data is not fetching correctly, if i am having blaks then it;s not eaither Yes or No, and also please make below changes if u can

1. Message box pop up should come to enter the multiple"Begins with Data " Ex: 4500,6500 etc....
2.After comletion of filtering "YES " (column F) data should be copied to the next sheet

attached is the sample excel file ...

Regards,
Hari
Regards,
Hari

Hi, Hari

Agian the data is not fetching correctly

Maybe that because something like "FUR/12-13/2214" appears in row 585?

Please Login or Register  to view this content.

For your information: a MessageBox will only be used to show information, theresīs no way to get information into that (thatīs what an InputBox is used for).

After comletion of filtering "YES " (column F) data should be copied to the next sheet

Lucky me: thereīs only one sheet in the sample workbook. But if I remember correctly you have received a code for Filtering and copying data in your other thread.

Ciao,
Holger