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:


[TABLE="width: 177"]
<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>[TR]
[TD="width: 64, bgcolor: transparent"]Site ID[/TD]
[TD="width: 75, bgcolor: transparent"]Site Activity[/TD]
[TD="width: 98, bgcolor: transparent"]Status[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 1[/TD]
[TD="bgcolor: transparent"]Activity 1[/TD]
[TD="bgcolor: transparent"]Not Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 1[/TD]
[TD="bgcolor: transparent"]Activity 2[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 1[/TD]
[TD="bgcolor: transparent"]Activity 3[/TD]
[TD="bgcolor: transparent"]Not Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 1[/TD]
[TD="bgcolor: transparent"]Activity 4[/TD]
[TD="bgcolor: transparent"]Not Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 1[/TD]
[TD="bgcolor: transparent"]Activity 5[/TD]
[TD="bgcolor: transparent"]Not Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 1[/TD]
[TD="bgcolor: transparent"]Activity 6[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 1[/TD]
[TD="bgcolor: transparent"]Activity 7[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 1[/TD]
[TD="bgcolor: transparent"]Activity 8[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 2[/TD]
[TD="bgcolor: transparent"]Activity 1[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 2[/TD]
[TD="bgcolor: transparent"]Activity 2[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 2[/TD]
[TD="bgcolor: transparent"]Activity 3[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 2[/TD]
[TD="bgcolor: transparent"]Activity 4[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 2[/TD]
[TD="bgcolor: transparent"]Activity 5[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 2[/TD]
[TD="bgcolor: transparent"]Activity 6[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 2[/TD]
[TD="bgcolor: transparent"]Activity 7[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 2[/TD]
[TD="bgcolor: transparent"]Activity 8[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 2[/TD]
[TD="bgcolor: transparent"]Activity 9[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 3[/TD]
[TD="bgcolor: transparent"]Activity 1[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 3[/TD]
[TD="bgcolor: transparent"]Activity 2[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 3[/TD]
[TD="bgcolor: transparent"]Activity 3[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 3[/TD]
[TD="bgcolor: transparent"]Activity 4[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 3[/TD]
[TD="bgcolor: transparent"]Activity 5[/TD]
[TD="bgcolor: transparent"]Not Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 3[/TD]
[TD="bgcolor: transparent"]Activity 6[/TD]
[TD="bgcolor: transparent"]Not Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 3[/TD]
[TD="bgcolor: transparent"]Activity 7[/TD]
[TD="bgcolor: transparent"]Not Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 3[/TD]
[TD="bgcolor: transparent"]Activity 8[/TD]
[TD="bgcolor: transparent"]Completed[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Site 3[/TD]
[TD="bgcolor: transparent"]Activity 9[/TD]
[TD="bgcolor: transparent"]Completed
[/TD]
[/TR]
</tbody>[/TABLE]


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