Hi guys

If I have a table of data, how do I create individual worksheets to contain
the different bits of info from the main table.

For example, if I have a 4 columned table and some of the entries in column
1 are "Apples", "Pears" etc, how do I get a worksheet to contain all of the
"Apples" data and call it "Apples", and then have a worksheet containing all
the "Pears" data and call it "Pears" etc etc etc?

Thanks muchly

Hi Dan,

See visit Ron de Bruin at:

Copy records with the same value in a column to a new sheet or workbook
http://www.rondebruin.nl/copy5.htm


---
Regards,
Norman




"Dan V" <(E-Mail Removed)> wrote in message
news:98763EEB-AD17-4C42-9006-(E-Mail Removed)...
> Hi guys
>
> If I have a table of data, how do I create individual worksheets to
> contain
> the different bits of info from the main table.
>
> For example, if I have a 4 columned table and some of the entries in
> column
> 1 are "Apples", "Pears" etc, how do I get a worksheet to contain all of
> the
> "Apples" data and call it "Apples", and then have a worksheet containing
> all
> the "Pears" data and call it "Pears" etc etc etc?
>
> Thanks muchly