I have a validation list in cell F5 in Tab ("Control_Sheet")
I code running that drops a date into another workbook
r = .Range("A" & Rows.Count).End(xlUp).Row
.Range("AO2").Formula = "=TEXT(NOW(),""mmm yy"")"
As opposed to using the date, can i reference where the user has selected the date
the workbook it is dropped into is called currentmonth.xlsx
So it will put the date Month and current year based on the dropdown in format "mmm yy"