Excel VBA for copy and past one sheet to another sheet when some criteria match

[khan_safi773]

Dear All,
I want transferred some data from "Sheet1" to another sheet which sheet name "Master File", both file head line are same,

My criteria is: Sheet1 column "Q" have some name, if Sheet1 column "Q" found "Safi" then match Sheet1 Column "B" with Master file Column "B", if sheet1 column "B" reference same with Master file column "B" reference same then Copy Sheet1 column E:T and past Master file same column E:T, Need VBA excel code for it


thanks in advance


Safi