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.

formulae can't do that. You would have to use a macro using MOVE

--
Don Guillett
SalesAid Software

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

THANKS!!!! :-)

"Don Guillett" wrote:

formulae can't do that. You would have to use a macro using MOVE

--
Don Guillett
SalesAid Software

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