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

I'd steal some code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

Brian Foss wrote:

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

--

Dave Peterson