Hello,

I have 2 WorkSheets (Sheet1 & Sheet2 )

Sheet1 is my main sheet where all data is stored first.

Sheet2 is where specific data is copied from Sheet1 if conditions met.

In Sheet1 there are 4 columns...Column 1 is for ID...Column 2 is for Name....Column 3 is for Address and Column 4 is for email-address

I want when "ID Column" contains "JACK" word............Data from Sheet1 of only column 1, column 2 & column 4 should be copied to Sheet2.

I DO NOT want it to copy Column 3(address column) and paste it Sheet2....I DO NOT want to copy the entire row.

Hopy you guys will be understanding what I mean.

Thank You