VBA Help need to Create Sheets and Sheet name as per cell values

**krjoshi** · 12-30-2011, 04:33 PM

Hi Folks,

I want to create new sheets when I click on the "Create Sheet" button (Sheet name should be same as values of Cells A2, A3, A4 till A10). If the Sheet name is already exist I want to show a warning message like "Some sheets already exist, Do you want to delete the existing sheet and create new?” And if I click on the "OK" button (in the Warming Message box) I want to create sheets If I click “Cancel” button nothing to do. Please help me.. I have attached a file of what I'm trying to accomplish. Thanks in advance for your expertise!

Thanks in advance.

Joshi

**arlu1201** · 12-31-2011, 05:39 AM

So should just blank sheets be created with no data in them? Or do you want some existing tab to be copied and then certain cells to be cleared so you can enter fresh data? Kind of like a template?

**Alf** · 12-31-2011, 07:16 AM

Perhaps like this?

Alf

**JapanDave** · 01-02-2012, 03:10 AM

I went a different approach to Alf(I did this a day or so ago, so may as well post it up).

Activate the cell you want to check if a sheet exist and click create sheet.

**krjoshi** · 01-03-2012, 02:48 PM

Hi JapanDeve,

Its almost OK, but I need to add one more criteria, If Sheet does not existing the macro should create new sheet based on active cell value "Sheet Name = Active cell value". Can you please help me?

Thanks in advance

Joshi