Hi All,
I need to a macro that will sequential date my worksheets with text and then a sequential number at the end.
i.e 06/01/18Page1, 07/01/18page2, 08/01/18Page3, 09/01/18Page4........
I probably be need to to end of year
Also, at the same time i need sheet2 from my workbook to be copied across to all the dates.
Can anyone help?
Thanks.
P.S VB novice here
I need to a macro that will sequential date my worksheets with text and then a sequential number at the end.
i.e 06/01/18Page1, 07/01/18page2, 08/01/18Page3, 09/01/18Page4........
I probably be need to to end of year
Also, at the same time i need sheet2 from my workbook to be copied across to all the dates.
Can anyone help?
Thanks.
P.S VB novice here
