Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CELL CONTENTS WRITE TO TAB NAME
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 | |||
CELL CONTENTS WRITE TO TAB NAME | Excel Worksheet Functions | |||
concatenate contents of cells whose contents resemble cell referem | 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) |