I'm very aware of that, but what I've stated is very clear and I have my
answer. I'm aware that I started another thread, BY MISTAKE, I meant to add
it to my previous one. WHAT DOES ANOY ME, that you seem to be adding just as
much treads with your comments. So please everyone! Please do not reply with
an answer or any more of your comments. Thanks

"Don Guillett" wrote:


A worksheet_change event can do that using copy/paste or .value = .value
but as Gord says, no mind reading here so you have to tell us what you want.
You do NOT do yourself a favor by arguing with people like Gord who is
trying to help you. And it is considered very impolite to start another
thread on the same subject. Do you really think that does any good. If your
attitude persists you will soon find no help around here.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Richard" wrote in message
...
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!!