VBA Sum Figure With Dates That Match Column Headings

Hi, I wonder whether someone may be able to help me please.

I'm trying to put together a script which performs the following:

• Compare the column date headings on the "Output" sheet with the dates in column D on the "In Flight Projects" sheet.

• If they match and the value in column C on the "In Flight Projects" sheet is "C&R", then

• Sum the figures in column E on the "In Flight Projects" sheet and,

• Paste the figure under the relevant column heading in row 8 on the "Output" sheet.

I do have some VBA knowledge but sadly it's certainly lacking when it come to something as complicated as this.

I just wondered whether someone could look at this please and offer some guidance on how I may go about achieving this please.

I appreciate that my description may not be the most clear, so I have attached a file which can hopefully illustrate this a little better.

It contains three sheets, the "In Flight Projects" data sheet, the "Output" sheet and the "desired Output" sheet which shows how I'd like the results to be displayed.

Many thanks and kind regards

Hi @Richard Buttery, thank you for taking the time for replying to my post.

Unfortunately, although I use the 2013 version at home , I'm using 2003 at work, so the second option would be better.

However I was really looking, if at all possible for a VB solution because this is being built as part of a bigger VB project which I've already written. It is also being used by users who are perhaps not quite as well versed in the use of Excel, so I thought a VB solution would be the simpler option.

Many thanks and kind regards

Christ,
I have hard time formatting your dates(Date is my favourite topic in excel). Jan 15 is recognised as Jan-14. To make life simple, I have to manually change some of the data in to dates. So, if you do not get any match, it is because of the date format.
I am off to watch Messi

Hi @Ruchard Buttery, thank you for this.

I've used the Sumproduct function before, but I wasn't aware you could incorporate this into VB.

Many thanks and kind regards

Hi Chris,
If you want to only consider cells which have C&R in column "C". If this does not give the correct result, I need to re-work the code.

Hi @AB33, thank you very much for coming back to me with this.

My apologies I thought I'd made this clear in my original post. Yes, it will only be for those records where the value in column C is "C&R".

Many thanks and kind regards

Chris,
Yes, I missed that bit and have amended it.
Have you tried post #8?

Hi @AB33, thank you for coming back to me with this, it is truly appreciate and it's absolutely no problem at all re. the "C&R" value.

I've tried the code and it works perfectly, thank you!

May I ask please, if you could possibly add some notes to the code. As always these have always been extremely helpful in expanding my knowledge.

Many thanks and kind regards

Chris