how do I transfer information from one sheet to another?

[Dan B.]

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?

[mrice]

You need to use a macro linked to the worksheet_change event. You test fir a Y in the target cell and initiate the copying.

[Dave Peterson]

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