Send or copy, either one, they are both the same. And yes it has to be
copied before it can be moved, else what are you moving? And what do you mean
by the event code. If I knew what is was and how to use it I wouldn't meed
any help with it. And as to where the data is being sent is on my post, sent
to sheet2 to the next available row!

"Gord Dibben" wrote:

"Send" means what?

Copy or Move?

The event code could do either.

To where would the data be "sent"?

To next empty row in sheet2 or overwrite the same row in sheet2 when data is
entered in a corresponding row on sheet1?


Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 09:28:00 -0800, Richard
wrote:

I'm trying to send the contents to another sheet without having to copy/paste
each time. Whenever something is entered into sheet 1 that row is sent to
sheet 2. I quess in the worksheet change event? Thanks in advance!!