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.

.Student	Subject	Marks
xya	English	100
abc	Hindi	20
uhs	Japanese	100
nncj	Chinese	50
ijdk	Tamil	80
aplo	Punjabi	100

<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>

 

[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.