I need to write a macro for a workbook with 1 sheet where i need to got to
data --> then select Group/outline ---> then select group
when the window opens in the start date it needs to get the latest date from the column "C" and the year from Column "A".
and end date should be 4 months from the start date.
Then select years and click ok.
Then save this workbook as "WeeklyClosingsReports and date(date should be the start date)"
date format: "mm/dd/yy".
Following is the code i get when i record this macro.
Sub clsrep()
Selection.Group Start:=39895, End:=40017, Periods:=Array(False, False, _
False, False, False, False, True)
End Sub