VBA code to move multiple date list to single date list

Microsoft Excel 010 - complete package
April 19, 2012 at 16:41:00
Specs: Windows 7
I need help writing VBA code in Excel to do the following:

Current data is in three columns
Can have more than one rows per date

Date Gallons Location
11/1/11 100 A
11/1/11 50 C
11/2/11 75 C
11/5/11 30 A
11/6/11 110 B
11/6/11 40 C
11/7/11 50 A
11/8/11 20 A
11/8/11 80 B

Need VBA code to move data to:
One row per date and gallons moved to corresponding Location columns

Date Gallons Location A Gallons Location B Gallons Location C
11/1/11 100 50
11/2/11 75
11/5/11 30
11/6/11 110
11/7/11 50
11/8/11 20 80


See More: VBA code to move multiple date list to single date list

Report •


#1
April 20, 2012 at 08:36:33
Do you need help writing the code or do you need someone to write the code for you?

In other words, have you tried anything? Post it if you have, after reading the blue line at the end of this post.

We'll see what help we can offer.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question