I would like to request Experts help to write a macro to compare data from “DataA” sheet (Column A to Column F) with data under “Type” category (Column B,D,F,H,J,L…) at “DataB” sheet. If the data matched, copy the matched data from DataB sheet (Number and Type) at Matched sheet. All missing data copied at the Missing sheet. I have manually copied few sample data at Matched and Missing sheet for Experts to get better view. Hope Experts will help me to create this feature.