Transferring data from one worksheet to another

Closed
Anoymous - Feb 17, 2015 at 01:20 AM
Hello,

I have a data dump where i need to run a macro which will segregate selected data to another worksheet:
For e.g.
Title Date/Time Resource Group Assignment Application
XYZ 12/12/12 Dave Service IT Java
ABC 13/12/12 Mike Ops Internal Oracle
PQR 14/12/12 Mark Admin Offshore Unix
UVW 15/12/12 Beth Ops External Linux

1. I need Ops data from Group field to be transferred to another worksheet &
2. Within Ops data I need Internal data to be transferred to another worksheet