Hi,
I have a workbook with an index page containing a list 1 - 20 (starting in cell A6) and 20 worksheets that correspond to that list. What I'd like to be able to do is automate the creation process into a macro button so that unskilled users can add another entry to the bottom of the list and in one click create a new sheet relating to that entry.
Sheets 1-20 are identical, as any new sheets would need to be - the only thing it would require is that the sheet name corresponds to the new entry - i.e. entry 21 on the list would result in a sheet being created called '21'.
Can anyone help with this please?
I have a workbook with an index page containing a list 1 - 20 (starting in cell A6) and 20 worksheets that correspond to that list. What I'd like to be able to do is automate the creation process into a macro button so that unskilled users can add another entry to the bottom of the list and in one click create a new sheet relating to that entry.
Sheets 1-20 are identical, as any new sheets would need to be - the only thing it would require is that the sheet name corresponds to the new entry - i.e. entry 21 on the list would result in a sheet being created called '21'.
Can anyone help with this please?