VBA code to collate data in different cells with same date

[Misoboii]

Hi, i have a problem here.

I have a huge list of data, with 9 columns: Date, A,B,C,D,E,F,G,H

I copied 2 set of Data (Date,A,B,C) and (Date,D,E,F,G,H) into 1 sheet together

After adding everything and filtering them by date, i have repeated dates, but some with data only in A,B,C and with the same date, only in C,D,E,F,G
eg:
date----------A-----B-----C------D------E------F------G------H
5/3/2011-----10-----20-----30-----__-----__-----__-----__-----__

5/3/2011-----__-----__-----__-----30-----50-----60-----10-----50

8/3/2011-----10-----20-----30-----__-----__-----__-----__-----__

9/3/2011-----__-----__-----__-----30-----50-----60-----10-----50

12/3/2011-----10-----20-----30-----__-----__-----__-----__-----__

12/3/2011-----__-----__-----__-----30-----50-----60-----10-----50
.
.
.
1.5k rows

I was wondering if there is a macro to combine all the repeated date cells data together into all 8 columns filled, while leaving the singular ones alone.

eg.
date----------A-----B-----C------D------E------F------G------H
5/3/2011-----10-----20-----30-----30-----50-----60-----10-----50

8/3/2011-----10-----20-----30-----__-----__-----__-----__-----__

9/3/2011-----__-----__-----__-----30-----50-----60-----10-----50

12/3/2011-----10-----20-----30-----30-----50-----60-----10-----50
.
.
.
1.5k rows

Any idea?

Thanks!

 

[hiker95]

Misoboii,

We can not use the flat text that you have displayed.

This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt that you would get an answer.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729