copy whole row starting from row # 2 on other sheet when the value in a column on 1st sheet is 100

[Dilip Darapureddy]

Hi

I want to copy the whole row to the second sheet in the same workbook when the marks are 100. Please help with the code
thank you very much in advance.
[TABLE="width: 144"]
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]
.Student[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]Subject[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]Marks[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]xya[/TD]
[TD="class: xl63, bgcolor: transparent"]English[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]100[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]abc[/TD]
[TD="class: xl63, bgcolor: transparent"]Hindi[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]20[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]uhs[/TD]
[TD="class: xl63, bgcolor: transparent"]Japanese[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]100[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]nncj[/TD]
[TD="class: xl63, bgcolor: transparent"]Chinese[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]50[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]ijdk[/TD]
[TD="class: xl63, bgcolor: transparent"]Tamil[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]80[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]aplo
[/TD]
[TD="class: xl63, bgcolor: transparent"]Punjabi[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]100[/TD]
[/TR]
</TBODY>[/TABLE]

 

[RickXL]

Hi.

You could try the AutoFilter.

Select your data.
Goto: Home-->Editing-->Sort & Filter-->Filter
Click the dropdown to select the scores of 100.
Copy the visible rows and paste into sheet2.