Hi Guys,

I am a learner with VBA and you guys have been my mentors and teachers for a while now (mostly i have been only reading) but now i face a problem of my own and would love if you could help me.

Basically i have two sheets representing project costs. 1 has project value and the other committed value.

What i am trying to do is combine the data from the two spreadsheets where:

* Each project needs to have it's own sheet (i.e. 1032B , 1032D...etc)
* Each new sheet (i.e. 1032B, 1032D...etc) needs to have all data for relating from both sheets where the first 4 letters in sheet("Cost type summary per project").Column("E:E") and sheet("Committed Costs").Column("H:H") are the same the value in sheet("Cost type summary per project").Column("I:I") and sheet("Committed Costs").Column("I:I") needs to be added up. (see example)



Capture.PNGCapture2.PNGCapture3.PNG

Here is my crappy code attempt 
Please Login or Register  to view this content.
If anyone has any ideas would be most appreciated.