PDA

View Full Version : [SOLVED:] Separating Names From this dynamic list and summing them into Preset Cells VBA Excel


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
Aussiebear
12-16-2013, 04:29 AM
Please post a workbook by clicking on Go Advanced, scroll down to Manage Attachments and follow the prompts from there rather than posting inside your text. Currently your post ( that is, your table setup is meaningless to most members here because its not VBA or Excel orientated.
SamT
12-16-2013, 09:39 AM
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
Kenneth Hobs
12-16-2013, 09:54 AM
=SUMIF($A$2:A25,"="&A2,$D$2:D25) and fill down.
emax79
12-16-2013, 01:38 PM
=SUMIF($A$2:A25,"="&A2,$D$2:D25) and fill down.

And Thank you to the man that fixed my code . I am new to this Site As well as Posting a Thread ........I Have learned alot .So Thank you guys .......