M
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
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