Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CELL CONTENTS WRITE TO TAB NAME
Select the sheet tab which you want to work with. Right click the sheet tab
and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Not Application.Intersect(Target, Range("A1:A10")) Is Nothing Then If Target.Count = 1 Then On Error Resume Next ThisWorkbook.Sheets(Target.Row + 1).Name = Target.Text End If End If Application.EnableEvents = True End Sub -- Jacob (MVP - Excel) "Pam M" wrote: I know there is a way to reference a worksheet name in a cell. Is there an automated way to name the sheet based on a cells contents? I have summary sheet with 200 names on it. Each name should have a corresponding worksheet. So, I want cell A1 with name1 to automatically name sheet2 as name1, and so on. That way, we have to update only the summary sheet and the worksheets will always co-incide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
nested Cell("contents", w/ cell contents reference) | Excel Worksheet Functions | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Write Contents of TextBox to new Workbook | Excel Discussion (Misc queries) | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) |