Copy an existing worksheet and create the same worksheet worksheet for each day of the year
Posted on 2011-03-13
I have a worksheet prepared in Excel for the Cashiers that needs to be prepared on daily basis. I am interested to copy that worksheet and have it prepared for each day of the year in the same workbook. But it will be time consuming if I do it manually.
I know that with macros I should be able to do that, but I don’t have any idea how to prepare it.
It would be perfect if the sheets are named as dates, for example: 3/1/2011, 3/2/2011, 3/3/2011 or it could be March 1 2011, March 2 2011.
Please let me know if you have any questions.
Thanks and Regards,