Autofilling of Dates between Date Ranges

[Jameo]

Hi all,

I basically have two seperate sheets. One with guarenteed pressures, and one with actual pressures.

I am looking to write a macro that will allow a user to select a start date and an end date, and then the results will be combined on another sheet.

The most simple way to combine this data in my opinion would be using a vlookup, however my problem comes with the formatting of the combined sheet.

Is there any way that I can get excel, through VBA, to auto fill the dates between the two selected date ranges?

Thanks in advance

 

[Jameo]

Hmm maybe something such as this?

Dim i As Long, j As Long
j = 1
With ActiveWorkbook
   For i = 0 To DateDiff("d", .Sheets(1).Range("a2"), .Sheets(1).Range("B2")) - 1
       If Format(DateAdd("d", i, .Sheets(1).Range("a2")), "ddd") = "Fri" Then
           .Sheets(2).Range("A1").Offset(j, 0).Value = Format(DateAdd("d", i, .Sheets(1).Range("A2")), "dddd, d MMMM yyyy")
           j = j + 1
       End If
   Next i
End With

Although I will have to modify is slightly as this is only used to populate fridays