Working code need to be expanded to full fill the need.

HI I have below code which was made by He Ho Be and later on moderated by Jb. But i need it to be more flexible. Now you select a sheet to search in and after you put in the search number or word, It search in column C and P. If it find a result i copy all row to sheet 2. I need still the selection of sheet. But the input box with search word need to be replaced by a range from sheet "Input" From A2 and down. So it loop throug all in the range and when it find a match it copy that row from Sheet 1 to Sheet 2. In this way i can choose to search with more numbers or words and find more than one match. I have below code and also i have attached a test sheet to work with,

Please have a look.

Thanks in advance
Sincerly
Abjac

My code.

Please Login or Register  to view this content.

Hi JB. Just went up here and saw your code. I have tested it and its a really great code. This is what i need to use sometimes.
Great code really.
Thanks allot and have a nice day.

Sincerely

Abjac