PDA

View Full Version : Code help with Aggregating Statements



Uller
04-01-2009, 03:38 PM
Hi all,

Please help me! I am trying to design a macro that will pull the totals that have been calculated from a monthly spreadsheet statement (attachment: SampleApple1) and insert those into an aggregated statement spreadsheet (Aggregates).

If you are looking at the two attachments, I am looking to take the numbers from the "Currency Conversion" column for each artist in SampleApple1 and essentially PasteSpecial Add those numbers onto the already existing totals in the Aggregate statement. Basically, I am just looking to apply them to the "Itunes" column under the corresponding Artist row from the SampleApple spreadsheet.

For example: Jesse Metcalfe amount on the Apple statement is 9.8. I am trying to have this amount added onto the Jesse total of 230 under the Itunes column in the Aggregate statement...and do the same for each artist on the SampleApple statement.

Any help would be much appreciated. Let me know!

Regards,

Uller

Please let me

Uller
04-01-2009, 03:40 PM
Here is the Aggregate spreadsheet