I need to copy data in a line from one worksheet to another if "col A"
returns a value of "1." I then need the original worksheet to delete the
information copied to the second worksheet.

Can anyone help me? Should it be a formula or macro? How should that macro
or forumla read?

Thanks.