Macro - Copy First Instance to Different Sheet

[smmeader]

I have a spreadsheet that contains a Revision Check criteria (Column AE). If the same number appears in column A twice, the value for Column AE will be 2. I would like to create a macro that will move the first instance (based on column A) to another sheet. I believe using a For and If/Then statement will work but I am having trouble making it.

Example:

Sheet 1 has values in Column A in Rows 1-20
Sheet 1 has two values in Column A that are the same (other info is different), which appear on rows 10 and 20.
Sheet 1 will have the value "2" in Column AE for these rows, and only these rows.
I would like to move the information from Row 10 into the next blank row of Sheet 2.

**My thinking is an IF statement would cycle through the sheet one row at a time. The value in AE is based on a COUNTIF formula (=countif(A$2:A$20,A2), so once the first instance is moved the value in Cell AE20 will change from 2 to 1 and therefore will not be moved when the macro gets to it.

Thanks for your help.

[patel45]

an attached sample may be helpful

[smmeader]

Please see attached. The Sheet1-Before is the original data. Sheet2 and Sheet1-After show the results after the macro has run.

Thanks.