Go to:
http://www.contextures.com/excelfiles.html

about 1/2 way down under "Files:"

Create New Sheets from Filtered List
This is a great example - download and apply
to your situation.

HTH

"hays4" wrote in
message ...

I have a master sheet, where users enter their data in rows.
One of the columns has a list, formatted using data validation, the
list has six options. For those 6 options I want the data sorted into
different sheets in the workbook.
How can I get the data on the master sheet - sheet1, to appear on the
next sheet - sheet2, with only those rows where option 1 was chosen.
And sheet3 contains those rows for option 2 ..
And so on for the other options.


--
hays4
------------------------------------------------------------------------
hays4's Profile:
http://www.excelforum.com/member.php...o&userid=28069
View this thread: http://www.excelforum.com/showthread...hreadid=484833