Copy a row of data from ne worksheet to another

[Galway]

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.

 

[Ron de Bruin]

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

 

[Galway]

Thank you!
This worked great.
T.

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

--

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





- Show quoted text -