emax79
12-15-2013, 06:41 PM
Hi Hopefully your Still Here Kenneth Or Any Kind Sir Madam ..... The other result worked perfect .Now that i Have them . I wish to Separate them Sir . I wish to do this in VBA . 10968Thank you again your a life saver . I have enclosed the workbook below ....
Name
Hours
Time
Commission
Aric 0
50
28
1431.6
How Do I go about Seperating these 7 names
Aric 0
36
8
309.1
Aric 0
15
7
113.9
And making there sum Go into lets say "h26": N26"
Aric 0
21.0
7.0
154.1
Aric 0
12.0
2.0
38.5
Thank you so much
Eric 0
28.4
Eric 1
14.7
Eric 2
10.5
Its dynamic so somestimes the list is longer or shorter
Eric 3
19.3
Eric 4
6.8
Ronnie 0
12.4
Ronnie 0
11.9
Ronnie 1
13.2
Ralph 2
8.5
Ralph 3
5.7
Harry 0
15.0
Harry 1
13.0
Harry 2
16.0
Harry 3
5.0
Vallerie
12.0
Vallerie
14.0
Vallerie
11.0
Vallerie
29.0
Vallerie
15.0
Name
Hours
Time
Commission
Aric 0
50
28
1431.6
How Do I go about Seperating these 7 names
Aric 0
36
8
309.1
Aric 0
15
7
113.9
And making there sum Go into lets say "h26": N26"
Aric 0
21.0
7.0
154.1
Aric 0
12.0
2.0
38.5
Thank you so much
Eric 0
28.4
Eric 1
14.7
Eric 2
10.5
Its dynamic so somestimes the list is longer or shorter
Eric 3
19.3
Eric 4
6.8
Ronnie 0
12.4
Ronnie 0
11.9
Ronnie 1
13.2
Ralph 2
8.5
Ralph 3
5.7
Harry 0
15.0
Harry 1
13.0
Harry 2
16.0
Harry 3
5.0
Vallerie
12.0
Vallerie
14.0
Vallerie
11.0
Vallerie
29.0
Vallerie
15.0