New to VB script here. I have a form that I created in Excel with a start and stop date. I have added the VB script to expand the start and stop date on my raw data sheet. I need some script to copy the rest of my form with the date expansion. Please help me out!
The form cells are C4-E4. Raw data page has the code pasted into Cell D based on the last available cell. Here is the code I have so far.
Dim FirstDate As Date
Dim LastDate As Date
Dim NextDate As Date
Dim LRow As Long
FirstDate = Worksheets("Form").Range("F4").Value
LastDate = Worksheets("FORM").Range("G4").Value
Worksheets("Raw Data Sheet").Select
LRow = Cells(Rows.Count, 4).End(xlUp).Row
NextDate = FirstDate
'selection of columns within one row
Do Until NextDate > LastDate
ActiveCell.Value = NextDate
NextDate = NextDate + 1