VBA Delete the name out from table

Dear all Friend & Expert,

I would like to make the VBA that after we add sheet in each cells and named in the sheet "main" that we add,
then need the name appear in table the same with sheet name, only one name in each sheet
in this VBA attached file only add sheet, not make the same format

as attached file

Good Morning Yukioh.

I'll give you a hand. Could you confirm for me what you would like to do?

You enter the details into the main sheet, then run the macro and it auto fills a template, based on the data from the Row and names the new sheet after the Name in column B

I've done what I think you were asking for. If there's anything else please just fire me a message.

If this was helpful to you please click the 'Add to Reputation' Star

Hi Richtea88

i have run on your code , there is some error,
how to do?

select a cell on the row you'd like a new page for then click button 1.

If it doesn't work can you send be the line of code that is causing the error

I've added another Error handler to stop an error occurring when you select and invalid row

now is working,
if i need another click on button 2 then let VBA add all sheet automatic how to do?

Just Click Button 1

RichTea88,
i just click it button 1, it added with all sheet, but without the name in each sheet in table

Hi all,
regarding to the VBA of RichTea88, I have try a VBA that RichTea88 help me, it work well,
but in the sheet that already created , it was no :
1) no any name in table after created sheet
2) when i double click on " button 1 " is said " A Sheet with that name already exists " , but when i deleted some sheet it still said that the same

as attached file

... some body help me pls

Hi Yukioh,
try it

Please Login or Register  to view this content.

Hi Nilem,
thank you so much for your kindly help,
is it possible that can you explain the code for me....

Good Morning Yukioh,

Apologies for not getting back to you over the weekend. Nilem seems to have cracked this one for you, so I'll leave you in his capable hands!

Hi Nilem & All Expert

after i try your code, it working well,
and i need the VBA to add hyperlink to the "main" sheet in each name ( Aa,Bb...etc) in each name on table name, when click to the name then let it link to that sheet, how to do?

Hi Yukioh,

I think I've managed to get my one working for you with Hyperlinks.

Give it a shot!

thank you somuch RichTea88

You're welcome Yukioh,

If you're happy with the solution can you click the Add Reputation Star on my post and mark the thread as solved using the Thread Tools at the top?