How can I copy the content of a row within a worksheet
to another worksheet if a certain criteria is met.
For example: If the value of A2 is "sales", then copy
the content of row 2 to worksheet 2. If the value of
row 3 is "marketing", copy the content of row 3 to
worksheet 3.

Brian