Hi

I want to run a macro to Segregate the data based on Multiple Criteria's in Multiple Columns. The data I get is basically from Outlook Mail Fields, which I run daily and generate an excel sheet every day, for further processing.

I have data like
In Sheet 1
Column B    Column C          Column D     Column E
Subject    Received Date      Sender      Body
Help         05/10/2012         a@co.com  Help Needed
Help         05/10/2012         b@co.com  Help Approved
Help         05/10/2012         CB@co.com  Help Approved
Help         05/10/2012         d@co.com  Help Done
Techno     05/10/2012         a@co.com  Techno Proposal
Techno     05/10/2012         b@co.com  Techno Proposal Approved
Techno     05/10/2012         OD@co.com  Techno Proposal Approved
Techno     05/10/2012         d@co.com  Techno Proposal Done
Process    05/10/2012         a@co.com  Process Change
Process    05/10/2012         b@co.com  Process Change Approved
Controll    05/10/2012         a@co.com  Controll Change
Which I want it Like this

In Sheet 2
Column B    Column C          Column D     Column E
Subject    Received Date      Sender      Body
Help         05/10/2012         a@co.com  Help Needed
Help         05/10/2012         b@co.com  Help Approved
Help         05/10/2012         CB@co.com  Help Approved   ****
Help         05/10/2012         d@co.com  Help Done
Techno     05/10/2012         a@co.com  Techno Proposal
Techno     05/10/2012         b@co.com  Techno Proposal Approved
Techno     05/10/2012         OD@co.com  Techno Proposal Approved   ****
Techno     05/10/2012         d@co.com  Techno Proposal Done
In Sheet 3
Column B    Column C          Column D     Column E
Subject    Received Date      Sender      Body
Process    05/10/2012         a@co.com  Process Change
Process    05/10/2012         b@co.com  Process Change Approved
Controll    05/10/2012         a@co.com  Controll Change
I will sort the data by "Subject" manually and look for "Sender" = "CB@co.com" or "OD@co.com", if found, then copy all related Rows with "Same Subject Line" to "Sheet 2"
and Other rows to "Sheet 2" (where "CB@co.com" or "OD@co.com" is not there)

I have searched in internet for Segregating data, but couldn't find anything related to my problem. I'm attaching excel sheet for your reference

I'm wondering is it possible to do this through VBA? it would make my work life better!! Please someone please help me...

Thanks a million in advance...
Sample_Outlook_File_Processed_Manually.xls