Horizontal then Vertical Loop help

[flindy87]

Hi,

I am trying to code a loop that basically looks at a start date and then an end date, if there is a gap between dates the loop will then +1 on to the start date in each column until it equals the end date. This will be filled out horizontol starting from column F.

I then need the loop to go down a row and start that process again.

I've attached the example workbook of data i need to apply the loop to.

Important note, the number of rows will be variable each time i run this report, i have already dim'd this variable with the below code

Please Login or Register  to view this content.

I am pretty much a beginner when it comes to loops so i have no code for this (no idea what to do!)

Any help is appreciated.

[Debraj Roy]

Hi,

Just the basic to hangout with For Loop...

Please Login or Register  to view this content.

[flindy87]

Thank you very much Debraj Roy!