Dear Excel Experts,
We have a Excel file, which we have using as template for all month, however, currently we are preparing day-wise tabs(work-sheets) into a workbook(attached) manually. For which we are looking automated way/process. i.e. after updating 1st day of the month in cell C1, it should create day-wise tabs(work-sheets) in a workbook
For example after updating 1-May-18 in cell C1
day-wise tabs(work-sheets) should be created as follows;
01-May, 02-May, 03-May, 04-May, 05-May, 06-May, 07-May, 08-May,09-May, 10-May, 11-May, 12-May, 13-May, 14-May, 15-May, 16-May, 17-May, 18-May, 19-May, 20-May, 21-May, 22-May, 23-May, 24-May, 25-May, 26-May, 27-May, 28-May, 29-May, 30-May, 31-May
and all worksheets C1 cell with tab(work-sheet) name
Please ref. attached workbook for details.
Thanks in advance.
Kravindra
Bookmarks