COPY/PASTE Row only if it has a value in a specific column

[Neuk]

First, I need to find if any cell in column AT has a value. If it has a value I need to copy the row with the value and paste it in another worksheet.
More specifically, I broke what I’m trying to do into three steps in a subroutine as follows:

Please Login or Register  to view this content.

Please see attached for a more descriptive picture of what I’m trying to do. Thank you for your time and help!

[vanthinh3101]

Copy code below to Module1

Please Login or Register  to view this content.

Have a nice day.

[Neuk]

Thanks vanthinh3101! That did it!