How do I Copy and paste row to another worksheet depending on cell value. e.g.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
Where any cell in column D of a Worksheet named "Clients" contains the word "Employed" then copy that row of the worksheet from Column A to G into the first available blank row in another worksheet named "Employed".<o
></o
>




Where any cell in column D of a Worksheet named "Clients" contains the word "Employed" then copy that row of the worksheet from Column A to G into the first available blank row in another worksheet named "Employed".<o

