I am newbie of VBA for excell. I had problem to combine two sheet which depend on first sheet. I want to solve this problem with VBA. Sheet "Plan" is for the reference and sheet "type" for the data to combine. Sheet result is the example of the combination that i want. Anyone can help me?PLAN.xlsx