Can't use Vlookup on data range

[milleroy]

Hi

I need your help to split up a data table in Excel

I have a 4 column range which has only 6 variants in Column A and would like to create a new sheet (in the same woorkbook) for each variant in Column A

I can't use Vlookup as there are muliple entries the same in A and I can't sort on the range.

The sheet looks something like this:

A B C D
1 AB 23 21
1 BA 12 32
1 AC 29 19
2 AC 12 99
2 AB 24 76
2 GA 34 56
2 AH 55 45
3 BS 23 39
3 AE 47 45
4
4
4
5
5
5
6
6
6

I haven't filled in every cell but I guess to get the idea.
The number of entries for each type in column A varies every day.

Can I use a function or is it VB?

I look forward to this solution. Many thanks
Roy

[Tom Ogilvy]

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

Ron de Bruin's site has sample code for this.

--
Regards,
Tom Ogilvy


"milleroy" <[email protected]> wrote in
message news:[email protected]...
>
> Hi
>
> I need your help to split up a data table in Excel
>
> I have a 4 column range which has only 6 variants in Column A and would
> like to create a new sheet (in the same woorkbook) for each variant in
> Column A
>
> I can't use Vlookup as there are muliple entries the same in A and I
> can't sort on the range.
>
> The sheet looks something like this:
>
> A B C D
> 1 AB 23 21
> 1 BA 12 32
> 1 AC 29 19
> 2 AC 12 99
> 2 AB 24 76
> 2 GA 34 56
> 2 AH 55 45
> 3 BS 23 39
> 3 AE 47 45
> 4
> 4
> 4
> 5
> 5
> 5
> 6
> 6
> 6
>
> I haven't filled in every cell but I guess to get the idea.
> The number of entries for each type in column A varies every day.
>
> Can I use a function or is it VB?
>
> I look forward to this solution. Many thanks
> Roy
>
>
> --
> milleroy
> ------------------------------------------------------------------------
> milleroy's Profile:
http://www.excelforum.com/member.php...o&userid=29870
> View this thread: http://www.excelforum.com/showthread...hreadid=512738
>

[milleroy]

Thanks Tom

That worked a treat. Saved me hours - many thanks.....

Roy