VBA Sumifs Loop

[SimonJF]

Hi All,

I am fairly new to VBA programing within excel and am really struggling to understand looping.
I am trying to run a VBA code that will sum the hours from "Data" sheet based on project numbers and dates (stored as text), and calculate the answers in a second sheet (Sheet 2); which has the projects listed vertically down through the rows and the dates horizontal along the top.

So far I have written the code which will allow me to sumifs the projects for the first column only (Jan-13), but am struggling to see how I can loop the formula to complete the remaining columns (Feb - Nov-13).

Can any please advise how I can modify the attached code to allow me to do this?

Thanks!

Simon

[sktneer]

Try this code.......

Please Login or Register  to view this content.

[davesexcel]

Check it example.

[SimonJF]

Sktneer, davesexcel,

Both of your codes do the trick perfectly! Thank you for your help with this.

Simon