How about an alternative?

Apply Data|Filter|Autofilter to that column that contains the Y's. Then filter
to show just the Y's. Then copy and paste those visible rows to the new
worksheet.

Personally, it would scare me to copy that row as soon as the user entered the
Y. If they hadn't finished changing all the cells on that row, it could be
premature. If they just made a typo, then the row would be gone and more work
would need to be done to correct it.



Dan B. wrote:

What I want to happen is if they put a "y" in the column then excel will
transfer all of their date (address, name) into another sheet. Is this
possible?

--

Dave Peterson