Help with auto creating sheets based on list

froojam

New Member
Joined
Dec 22, 2005
Messages
1
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?
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,118,236
Messages
5,571,050
Members
412,359
Latest member
misstoffeepenny
Top