I only know basic Excel, so this one is rough for me. Here's my problem.

I have one Excel 2003 file with 2 sheets. I'm trying to make it so that
when the data is filled for one row on sheet 1 (using a colum to mark 'x' for
complete), it will transfer to the next empty row on sheet two, and delete
that row from sheet one. Here's an example..

Row 4 on sheet 1 has all the info it needs, so the user marks X on column J.
When that column on row 4 is marked X, it will copy that row to the next
empty row on sheet 2, and then delete that row from sheet 1.

Is there any way to do this? I'm sure there is, but I'm unsure on how to do
it. Please respond with any advice you can offer. You can also email me the
how-to at . Thank you all for whatever help you can offer.