• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

roypabitra

Member
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
 

Attachments

  • sample1.xls
    59 KB · Views: 6
Hello, according to the Excel basics advanced filter that needs a single VBA codeline with a smart enough OUTPUT worksheet :​
click ► Smart.jpg
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 !
 
Back
Top