Find numbers in column and copy row data to new sheet

[omnivl]

I have a sheet which i import and in column A i have a sequence of numbers 1,2,3,4,5 etc

1	Text	10	1	2
2	Text	7	1	1
3	Text	8	1	3

<tbody>
</tbody>

I would like to copy each row of data into a new sheet called scoring, any help would be awesome

 

[My Aswer Is This]

Why not just use this script to make a copy of the entire sheet.
This script assumes the current sheet is named "Master" modify if needed.

Sub Copy_Master()
Sheets("Master").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = "scoring"
End Sub

 

[omnivl]

Perfect thanks!

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

Perfect thanks!