Copy data in new sheet from list of data in a row of diffrent sheet if condition match

[roypabitra]

Respected Sir,

I have a data sheet like below :

Note No. Date Name Bill No.
10522 12/04/2017 Jones 123/17-18
10523 18/04/2017 Ram 123/17-18
10524 22/04/2017 Shyam 126/17-18
10526 10/05/2017 Pabitra 128/17-18
10527 15/05/2017 Jones 126/17-18
10226 19/05/2017 Ram 123/17-18

As per sheet1 of sample file attached

Now I want to copy all the data if bill no match in sheet2 as per sheet2 of sample file attached

Please help me how to match my condition.

Thanking you
Yours faithfully

Pabitra Roy

 

[Naresh Yadav]

Hi,

Pls see if this works for you

regards
Naresh

 

[roypabitra]

Respected Sir,

Thanks for your prompt reply But when I clear the filter the formula is not working properly. is it not possible through VBA code? If yes please assist me how to implement it.

Thanks & Regards

Pabitra

 

[Marc L]

Hi !

Here it's the Excel section, not the VBA forum …​

 

[pecoflyer]

AFAIK this problem has been addressed and solved many times. Check the Net