How to split data based on a few criterias and paste to multiple sheets - VBA help!|VBA & Macros|Excel Forum|My Online Training Hub

Hey, I want to split data in master data sheet based on some criterias, and then copy the data to different destination tabs accordingly,

criteria 1: = column email <>"", then copy paste them to sheet "email",

criteria 2: = column email ="" and column address <>*lost*, then copy paste them to sheet "address"

criteria 3: = column mobile <>"", then copy paste them to sheet "mobile"

can someone help me with the code to run above?

thanks!!!