Macro To Copy Unique Data

[Dazzawm]

I have a lot of rows and columns on sheet1 with various data. What I need the macro to do is look at column 'H' then column 'G'. As you can see rows 1-4 and 6-7 have the same data in column 'H' but a choice of Manual or Automatic in column 'G'. I want just the ones with Automatic only (not all rows with automatic in) copied onto sheet 2, like rows 5 and 8. Thanks.


Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 67px"><COL style="WIDTH: 67px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt"><TD> </TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">MANUAL</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS4_43A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">MANUAL</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS4_43A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS4_43A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS4_43A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS4_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS5_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">MANUAL</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS5_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS5_35D</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR></TBODY></TABLE>

Sheet2

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 67px"><COL style="WIDTH: 67px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS4_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS5_35D</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR></TBODY></TABLE>

 

[Dazzawm]

If its easier the entire rows dont have to be copied over just columns G and H, into say A and B on sheet 2.

 

[JackDanIce]

Instead of a macro, you could:

1) Copy Sheet1 into a new sheet
2) Insert a column next to column H
3) Insert the formula:

=COUNTIF($H$2:$H$200,H2)

(Change 200 to whatever your last row is)

4) Then filter your data, first by column I for values of "1" only and then by column G for values of "Automatic" only which would leave what you want

 

[Dazzawm]

That does not do as I want. I may have a return of 8 from the formula where 7 may be manual and 1 automatic. So i need to ignore that. What I need is maybe a return of 4 or 8 where they are all automatic and none of them manual. Thats what I need copied over.

 

[JackDanIce]

Have you actually tried my suggestion? Using the data you provided, I get the filtered results that you expect. I then copy these into a new sheet and delete the filtered sheet, leaving the original sheet (Sheet1) and the subset of rows that you're after.

 

[Dazzawm]

Have you actually tried my suggestion?

Yes I have, the formula you suggests counts how many cells/rows there are with the same data in column 'H'. If I have a return of 1 it means there is only one row with unique data, that may or may not have manual or automatic next to it in 'G'. The '1' does not really come into play because I know there is a group of 4 rows where they are all automatic and not manual so I need those copied onto sheet 2.

 

[JackDanIce]

The data you have posted suggests you only want rows where the value in G is "AUTOMATIC" and the value in H is unique, that is exactly what my suggestion does.

The '1' does not really come into play because I know there is a group of 4 rows where they are all automatic and not manual so I need those copied onto sheet 2.

Your example does not show 4 rows that are automatic being copied over, so I'm afraid I don't understand your requirement or your desired output needs modifying to show better clarity of what you want.

 

[JackDanIce]

The data you have posted suggests you only want rows where the value in G is "AUTOMATIC" and the value in H is unique, that is exactly what my suggestion does.

The '1' does not really come into play because I know there is a group of 4 rows where they are all automatic and not manual so I need those copied onto sheet 2.

Your example does not show 4 rows that are automatic being copied over, so I'm afraid I don't understand your requirement or your desired output needs modifying to show better clarity of what you want

 

[Dazzawm]

Maybe I was not very clear, as below in green are automatics only so they need copying to sheet2, there may be more than 1 row as there may be different data in other cells within the row which does not matter in this instance. In yellow are a mixture of manual and automatic so they need to be ignored.

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 86px"><COL style="WIDTH: 67px"><COL style="WIDTH: 67px"><COL style="WIDTH: 86px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">MANUAL</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS4_43A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">MANUAL</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS4_43A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS4_43A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS4_43A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS4_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS4_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS4_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS4_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS4_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS4_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS5_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">MANUAL</TD><TD style="BACKGROUND-COLOR: #ffff00; FONT-SIZE: 8pt">LSGS5_35A</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS5_35D</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS5_35D</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS5_35D</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">AUTOMATIC</TD><TD style="BACKGROUND-COLOR: #99cc00; FONT-SIZE: 8pt">LSGS5_35D</TD><TD style="FONT-SIZE: 8pt">VARIOUS DATA</TD></TR></TBODY></TABLE>

 

[Dazzawm]

I hope I have explained myself more clearly now, sorry!