Can't use Vlookup on data range
 

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

Can't use Vlookup on data range
 

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

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

--
Regards,
Tom Ogilvy


"milleroy" wrote in
message ...

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

Can't use Vlookup on data range
 

Thanks Tom

That worked a treat. Saved me hours - 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