Copy a row of data from ne worksheet to another
 

I have an excel workbook with two worksheets,
I need to cut any row that has "Complete" in a specific cell from
worksheet 1.
Then paste it onto worksheet 2 on the next available row.
T.

Copy a row of data from ne worksheet to another
 

See this example
http://www.rondebruin.nl/copy5.htm#Add

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Galway" wrote in message ...
I have an excel workbook with two worksheets,
I need to cut any row that has "Complete" in a specific cell from
worksheet 1.
Then paste it onto worksheet 2 on the next available row.
T.

Copy a row of data from ne worksheet to another
 

Thank you!
This worked great.
T.


On May 14, 1:15*pm, "Ron de Bruin" wrote:
See this examplehttp://www.rondebruin.nl/copy5.htm#Add

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Galway" wrote in ...
I have an excel workbook with two worksheets,
I need to cut any row that has "Complete" in a specific cell from
worksheet 1.
Then paste it onto worksheet 2 on the next available row.
T.- Hide quoted text -

- Show quoted text -