VB Code to filter data and copy paste in another sheet

Hello:

Please refer to attached file.
Have data as shown in Sheet1
I need to filter the data in sheet2 with date given is sheet2 cell B1 and vendor in cell A2

Result needs to be as shown in Sheet2.

Let me know if you have any questions.
Thanks.

R

Hi !

The very beginner easy way is an advanced filter but you have to put headers in Sheet2 A1:B1, data to search in A2:B2
then the code needs only a single codeline as you can see in the VBA inner help of the AdvancedFilter method …

Set up the Criteria range as Marc stated and try this...

Please Login or Register  to view this content.

Hello:

Thanks to all , works for me

R

As a beginner starter :

PHP Code: 

Sheet1.UsedRange.Advancedfilter xlFilterCopy, Sheet2.[A1:B2], Sheet2.[A4:L4] 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

Thank you, good to learn somthing every day :D