Add a new sheet depending on cell value

[stagiairebmh]

Hi, I'm trying to write a code which would add a new sheet and name it, depending on the value of a cell.

There would be a drop down list, then if an item is selected, a new sheet is created and named after the value of the cell.

In my case, the cell is A2, and the choice is 1,2,3,4,5 and the corresponding sheet would be 1N,2N,3N,4N,5N. It works perfectly.

My only problem is that I'd like it to erase the sheet and create another if the value is changed.

For example:

If i select 1, the sheet 1N is created, but if I change my choice to 2, the 1N sheet is deleted, and 2N is created.

Here's an example sheet

[jindon]

for the workbook provided.

Please Login or Register  to view this content.