Copy data from one sheet to another if criteria met

[Nathan_21]

Hi,

I have aset of data on one sheet, with multiple site ID's but each ID will have adifferent set of data as below, once this data has all met a certaincriteria I want to move it onto a new tab the data set is below as an example:

Site ID	Site Activity	Status
Site 1	Activity 1	Not Completed
Site 1	Activity 2	Completed
Site 1	Activity 3	Not Completed
Site 1	Activity 4	Not Completed
Site 1	Activity 5	Not Completed
Site 1	Activity 6	Completed
Site 1	Activity 7	Completed
Site 1	Activity 8	Completed
Site 2	Activity 1	Completed
Site 2	Activity 2	Completed
Site 2	Activity 3	Completed
Site 2	Activity 4	Completed
Site 2	Activity 5	Completed
Site 2	Activity 6	Completed
Site 2	Activity 7	Completed
Site 2	Activity 8	Completed
Site 2	Activity 9	Completed
Site 3	Activity 1	Completed
Site 3	Activity 2	Completed
Site 3	Activity 3	Completed
Site 3	Activity 4	Completed
Site 3	Activity 5	Not Completed
Site 3	Activity 6	Not Completed
Site 3	Activity 7	Not Completed
Site 3	Activity 8	Completed
Site 3	Activity 9	Completed

<colgroup><col width="64" style="width: 48pt;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2673;"> <col width="98" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3470;"> <tbody> </tbody>

Once allactivity are completed on the site I want one line with the site ID moving to anew tab saying its completed, and only once its completed should it move to thenew Tab.



Verygrateful for all the help in advance