I have a master sheet, where users enter their data in rows.
One of the columns has a list, formatted using data validation, th
list has six options. For those 6 options I want the data sorted int
different sheets in the workbook.
How can I get the data on the master sheet - sheet1, to appear on th
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

--
hays
-----------------------------------------------------------------------
hays4's Profile: http://www.excelforum.com/member.php...fo&userid=2806
View this thread: http://www.excelforum.com/showthread.php?threadid=48483