VBA code required for extract data from data sheet to another output sheet

[roypabitra]

Respected All friends

I am excel learner and want VBA code for extract data from data sheet to another output sheet if criteria matched from data sheet as sample file attache

Please share vba code for the same

Thanks & Regards

Pabitra Roy

 

[p45cal]

Won't a pivot table do?

 

[roypabitra]

Respected Sir,

I need only VBA only

Regards

Pabitra Roy

 

[Marc L]

Hello, according to the Excel basics advanced filter that needs a single VBA codeline with a smart enough OUTPUT worksheet :​

​

click ► ​

​

So just using the Macro Recorder like any Excel user operating manually : [Data!A2].CurrentRegion.AdvancedFilter 2, [A1:A2], [C1:D1] …​

​

Do you like it ? So thanks to click on bottom right Like !​

​