Hello Great people,
I am new to Excel VBA Macros and would like to know how to Create new sheets based on a date list on another sheet within the same workbook. I want the sheets to be named after the dates. Kindly assist with the code, like a format.
the date list is found in two worksheets named "PURCHASES" and "SALES", in range "G4: lastcell" on both worksheets. I want the newly generated sheets to be named sequentially and if any date is entered in the cells, they should be updated automatically on the worksheet names.
i need the code guide please.
I am new to Excel VBA Macros and would like to know how to Create new sheets based on a date list on another sheet within the same workbook. I want the sheets to be named after the dates. Kindly assist with the code, like a format.
the date list is found in two worksheets named "PURCHASES" and "SALES", in range "G4: lastcell" on both worksheets. I want the newly generated sheets to be named sequentially and if any date is entered in the cells, they should be updated automatically on the worksheet names.
i need the code guide please.