Hi,
I m a newbie to this, Need help to filter multiple columns using input boxes with 4 different criterias at one go using vba macro and paste onto a new sheet.
Here's a sample Data
col-A col-B col-C col-D col-E col-F
SPOC RECNAME DOBIRTH QUALIFICATION DORESG UNIV
Rajeev Manoj 12-06-1981 BSC 10-04-06 Mumbai
Naveen Vinod 04-05-1980 BCom 19-08-09 Mumbai
Shree Ramesh 17-05-1984 MBA 21-05-07 Mumbai
....
We have this kind of data for approx 5000 rows,
Now here's what I need
From the above data on sheet1 I need to filter on the first four columns
I need to auto fileter on the criteria's as mentioned in the input box. The input box will be for user to enter desired filtering option to fileter on the specific coulmn. He can select all or any of the options or only one option leaving other boxes blank. Depending on the input in the box the macro should then filter on all the required columns and pull the information to a nes sheet say Sheet2
Say for instance I need
SPOC : Rajeev
RECNAME : Manoj
DOBIRTH : 12-06-1981
QUALIIFCATION : BSC
I hope I have given all information. In case if anyone needs more data I can help them out. Please if anyone can help me with it will be great.
Thnaks & Regards
Joby
I m a newbie to this, Need help to filter multiple columns using input boxes with 4 different criterias at one go using vba macro and paste onto a new sheet.
Here's a sample Data
col-A col-B col-C col-D col-E col-F
SPOC RECNAME DOBIRTH QUALIFICATION DORESG UNIV
Rajeev Manoj 12-06-1981 BSC 10-04-06 Mumbai
Naveen Vinod 04-05-1980 BCom 19-08-09 Mumbai
Shree Ramesh 17-05-1984 MBA 21-05-07 Mumbai
....
We have this kind of data for approx 5000 rows,
Now here's what I need
From the above data on sheet1 I need to filter on the first four columns
I need to auto fileter on the criteria's as mentioned in the input box. The input box will be for user to enter desired filtering option to fileter on the specific coulmn. He can select all or any of the options or only one option leaving other boxes blank. Depending on the input in the box the macro should then filter on all the required columns and pull the information to a nes sheet say Sheet2
Say for instance I need
SPOC : Rajeev
RECNAME : Manoj
DOBIRTH : 12-06-1981
QUALIIFCATION : BSC
I hope I have given all information. In case if anyone needs more data I can help them out. Please if anyone can help me with it will be great.
Thnaks & Regards
Joby