Automaticaaly Naming Sheets/Tabs from Cell

Hi,

Can anyone point me to or let me know the macro used to automatically name a tab/sheet from a specific cell o a different tab/sheet?

I have been able to find this for cells on the same sheet/tab but not for accessing cells on a different one.

Thanks in advance

Warwick

try something like

Please Login or Register  to view this content.

Hi,

Thanks for getting back so quickly, just a quick clarification if I may?

The code above is placed in the worksheet -> selection change of the sheet whose name I wish to change

and in thecode I need to replace as follow:

Sub a()
Dim x As Long
For x = 1 To ActiveWorkbook.Sheets.Count
Sheets(x).Name = Sheets(Sheetname that holds the cell).Rows(rownumber in numeric format).Columns(columnnumber in numeric format)
Next x
End Sub

Thanks Again

Hi
this will change the name of the active sheet whenever the selection changes on the active sheets:

Please Login or Register  to view this content.

Hi,

Try this attached workbook and let us know is it for searching .

Thanks - Naveed.

Thanks NickyC but I could not get that to work. I placed it in the worksheet->selectchange and used the A1 to insert the sheet name and nothing happened. I am new to this so I am sure it is something I am doing wrong.


Thanks to you too Naveed, it does change the tab names but I am hoping it may be possible to automate the process.

I am trying to create a small family tree spreadsheet, where the first sheet is a 4 generation pedigree chart from which I input name birth, marriage and death information. The cell with the persons name is the cell used to automatically name other sheets which will contain more specific individual information

2012-12-12_10-29_Microsoft Excel.jpg

As can be seen by the image which I manually set up I am hoping to automate the process so that sheet person1 gets its name from sheet '4 gen Pedigree Chart' cell B15,
person2 gets its name from sheet '4 gen Pedigree Chart' cell E7, person3 gets its name from sheet '4 gen Pedigree Chart' cell E23, etc etc.

I hope this makes sense.

Thanking you in advance

Warwick

Hi

given the compexity of what you're doing, linking your macro to a sheet change event could get a bit messy. Try using an ordinary macro.
Without seeing all of your sheet it's a bit hard to come up with a macro for you, but assuming the names you want to use are in columns B, E, H and K, and the names are evenly spaced in your spreadsheet (same number of rows between namesi in each column), something like this should work:

Please Login or Register  to view this content.

place this code in thisworkbook and click run

Please Login or Register  to view this content.

it will change the sheet name and also cell A1 according to a text or value in cell A2 in Sheet1. If you want to change the name of all sheet, let say 10 sheets, change the i=2 into For i=2 to 10. and below code "Worksheets(i).Range("A1") = Worksheets(i).Name", type Next i.

This sounds sort of like something I'm trying to accomplish as well. Although I'm trying to work with data from a master sheet and have it automatically create new tabs based on the A1, A2, or A3 (etc.) value. What I would like to end up with is one tab named per Ax instance as they are updated or created. Any help would be greatly appreciated. And yes, I'm new to excel programming but not to computers.

Hi all, I think I am starting to think like MarvinP. I might be biting of more than I can chew. Got to start somewhere though.