Filtered info, into next sheet

[hays4]

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.

[Jim May]

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" <hays4.1yhnnn_1131974703.1638@excelforum-nospam.com> wrote in
message news:hays4.1yhnnn_1131974703.1638@excelforum-nospam.com...
>
> 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
>

[hays4]

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 enter another row onto the master sheet, then run the macro again. I have tried but my new entry doesn't get copied across...

[Tom Ogilvy]

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

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

--
Regards,
Tom Ogilvy


"hays4" <hays4.1yhnnn_1131974703.1638@excelforum-nospam.com> wrote in
message news:hays4.1yhnnn_1131974703.1638@excelforum-nospam.com...
>
> 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
>

[hays4]

THANKYOU,

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

thanks