Macro to group and save.

 swe1 -

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

Thanks in advance.

1 reply

Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month