Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Merge a series of rows with the same ID reference to a single row automatically using VBA.

  Asked By: Willie    Date: Oct 07    Category: MS Office    Views: 1143
  

Merge a series of rows with the same ID reference to a single row
automatically using VBA.

For example:

ID Name Amount
200 Majirius 120
200 Majirius 100
200 Majirius 200
300 Bonaventure 200
300 Bonaventure 120
400 Louis 100
500 Bernard 50
500 Bernard 50
500 Bernard 100

Should become:

ID Name Amount1 Amount2 Amount 3
200 Majirius 120 100
200
300 Bonaventure 200 120
400 Louis 100
500 Bernard 50 50
50

Thank you in advance for helping me post this problem.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Leroy Schmidt     Answered On: Oct 07

This file should help get you started

http://www.geocities.com/txyaaj/count_stuff.xls

 




Tagged: