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

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

Thanks, this is great, it is nearly what I'm trying to do.

Having run the macro, and it works brilliantly, I want to then ente
another row onto the master sheet, then run the macro again. I hav
tried but my new entry doesn't get copied across..

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

http://www.rondebruin.nl/copy5.htm

at Ron de Bruin's site may have some application.

--
Regards,
Tom Ogilvy


"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

THANKYOU,

these links are SO helpful, they are exactly what I need,

thanks


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