Formula - add worksheet name whe a new worksheet is added - help needed

[Dhamo]

Hi,


I have a common sheet named 'Summary' and in that, I have all other sheets name for some calculations. If the user adds a new sheet then the new sheet name should be added to the summary sheet.


I need formula only and not macro.


Please help.


- Dhamo

 

[Debraj]

Hi Dhamo,


As you are a regular member of this site.. its hard to remember.. what you have already posted..


http://chandoo.org/forums/topic/formula-create-sheet-name-in-summary-sheet-when-a-new-sheet-is-created


Regards,

Deb

 

[Dhamo]

Good catch Deb.. It my mistake. I am sorry. Apologies

by the way, Can you please post a sample file with the formula you suggested last time?

 

[sgmpatnaik]

@Dhamo


Hi


Have a look in the below link you can get some idea


http://www.mrexcel.com/forum/excel-questions/32203-insert-tab-name-into-worksheet.html


http://www.extendoffice.com/documents/excel/790-excel-insert-sheet-names-in-cells.html


add the below code for immediate insert sheet names in the summary sheet


Private Sub Worksheet_Activate()

Columns(1).Insert

For i = 1 To Sheets.Count

Cells(i, 1) = Sheets(i).Name

Cells(i, 2) = delet

Next i

End Sub


Thanks


SP