You sort of provided some more details<g

"each time something is added to sheet1"..........where?

In row 1 again? Or row 2 then row 3 then row 4?

If the latter, in A1 of sheet2 enter =IF(Sheet1!A1="","",Sheet1!A1)

Copy across to B1

Select both of those cells and drag/copy down as far as you wish.

As you fill up columns A and B on sheet1 the results will be shown on sheet2

If all your data entering is going to be in Sheet1 A1 and B1 you will need VBA


Gord

On Sat, 8 Mar 2008 11:16:03 -0800, Richard
wrote:

Say I put RT-005 in sheet1 columnA cell a1 and I put a qty of 5 in sheet1
columnB cell b1. I want to be able to send those results to sheet2 starting
at row1 and each time something is added to sheet1 those results are sent to
sheet2 to the next row and so on

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