I have a workbook with one worksheet named 0 which will serve as a template and a worksheet named data.
I need help with a macro to copy sheet 0, a command button for this macro would be placed in sheet data.
Every time the macro button is pushed it would create an additional copy of sheet 0 in the same workbook,
each new sheet being automatically named one consecutive number higher than the highest numbered worksheet name currently in the book also putting that sheet name/number in cell h3 of each new sheet.
So I could push this button 100 times and end up with 100 copies of sheet 0, with the sheet names being numbered 1 through 100 and having the sheet name in each sheet's cell h3.
I need help with a macro to copy sheet 0, a command button for this macro would be placed in sheet data.
Every time the macro button is pushed it would create an additional copy of sheet 0 in the same workbook,
each new sheet being automatically named one consecutive number higher than the highest numbered worksheet name currently in the book also putting that sheet name/number in cell h3 of each new sheet.
So I could push this button 100 times and end up with 100 copies of sheet 0, with the sheet names being numbered 1 through 100 and having the sheet name in each sheet's cell h3.