Hello all,
Im needing a macro when pressed to Copy range("T:AD") to new sheet in "A1" and to copy the sheet the amount of time as the number of days in the month that's in "AD1"
Ex. if AD1=12/1/2020 then to copy the sheet 31 times as there are 31 days in December.
with each New sheet to change the value in "K1" to next day. and rename the sheet to value of "K1" with the "DD" format.
any help is greatly appreciate.
Im needing a macro when pressed to Copy range("T:AD") to new sheet in "A1" and to copy the sheet the amount of time as the number of days in the month that's in "AD1"
Ex. if AD1=12/1/2020 then to copy the sheet 31 times as there are 31 days in December.
with each New sheet to change the value in "K1" to next day. and rename the sheet to value of "K1" with the "DD" format.
any help is greatly appreciate.