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!!