• 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.

Macro for specific criteria..

Hello Excel Gurus,

How to write Macro for extracting data for this attached sheet. for example please see the attached two sample workbook in which one is Source data sheet and 2nd one Macro_CD workbook is where data to be extracted.
Thanks so much.
 

Attachments

  • Macro_CD.xlsx
    11.8 KB · Views: 2
  • S_data.xlsx
    9.6 KB · Views: 2
Hi:

Find the attached. Save your master workbook in the same path as this macro work book. I have used the name S_data for your main work book , you may have to change the name in the code as per your need.

Thanks
 

Attachments

  • Book1.xlsm
    18 KB · Views: 4
Back
Top