I would like to see I can create a new sheet from souce data that we create
a new sheet from a group of data and name the sheet after the group and copy
the data into the sheet...

so the below would create 3 new sheets called a,b,c and would hold the data
against each group...

so 1 sheet would be a and hold a1 to e5 data in it...

a b c d e
Group Data
1 a aa aa aa aa
2 a aa aa aa aa
3 a aa aa aa aa
4 a aa aa aa aa
5 a aa aa aa aa
6 b bbb bbb bbb bbb
7 b bbb bbb bbb bbb
8 b bbb bbb bbb bbb
9 b bbb bbb bbb bbb
10 b bbb bbb bbb bbb
11 b bbb bbb bbb bbb
12 b bbb bbb bbb bbb
13 b bbb bbb bbb bbb
14 b bbb bbb bbb bbb
15 c cccc cccc cccc cccc
16 c cccc cccc cccc cccc
17 c cccc cccc cccc cccc

You can start here
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"PR" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
>I would like to see I can create a new sheet from souce data that we create
> a new sheet from a group of data and name the sheet after the group and copy
> the data into the sheet...
>
> so the below would create 3 new sheets called a,b,c and would hold the data
> against each group...
>
> so 1 sheet would be a and hold a1 to e5 data in it...
>
> a b c d e
> Group Data
> 1 a aa aa aa aa
> 2 a aa aa aa aa
> 3 a aa aa aa aa
> 4 a aa aa aa aa
> 5 a aa aa aa aa
> 6 b bbb bbb bbb bbb
> 7 b bbb bbb bbb bbb
> 8 b bbb bbb bbb bbb
> 9 b bbb bbb bbb bbb
> 10 b bbb bbb bbb bbb
> 11 b bbb bbb bbb bbb
> 12 b bbb bbb bbb bbb
> 13 b bbb bbb bbb bbb
> 14 b bbb bbb bbb bbb
> 15 c cccc cccc cccc cccc
> 16 c cccc cccc cccc cccc
> 17 c cccc cccc cccc cccc
>
>

Ron
many thanks for this, it seems a good place to start...

regards - Paul

"Ron de Bruin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You can start here
> http://www.rondebruin.nl/copy5.htm
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "PR" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>>I would like to see I can create a new sheet from souce data that we
>>create a new sheet from a group of data and name the sheet after the group
>>and copy the data into the sheet...
>>
>> so the below would create 3 new sheets called a,b,c and would hold the
>> data against each group...
>>
>> so 1 sheet would be a and hold a1 to e5 data in it...
>>
>> a b c d e
>> Group Data
>> 1 a aa aa aa aa
>> 2 a aa aa aa aa
>> 3 a aa aa aa aa
>> 4 a aa aa aa aa
>> 5 a aa aa aa aa
>> 6 b bbb bbb bbb bbb
>> 7 b bbb bbb bbb bbb
>> 8 b bbb bbb bbb bbb
>> 9 b bbb bbb bbb bbb
>> 10 b bbb bbb bbb bbb
>> 11 b bbb bbb bbb bbb
>> 12 b bbb bbb bbb bbb
>> 13 b bbb bbb bbb bbb
>> 14 b bbb bbb bbb bbb
>> 15 c cccc cccc cccc cccc
>> 16 c cccc cccc cccc cccc
>> 17 c cccc cccc cccc cccc
>>