| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make tab name match cell on another sheet?
I have a set of tabs in a workbook template. I would like to have some of the
exsisting tabs automatically rename according to specific cells on another sheet. example: cells 1-10 in column A of the 1st tab have text: "Week01" - "Week10" name of 2nd tab = cell A1 in 1st tab ("Week01"). name of 3rd tab = cell A2 in 1st tab ("Week02"). name of 4th tab = cell A3 in 1st tab ("Week03"). ......and so on. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a cell = the sheet name? | Excel Discussion (Misc queries) | |||
| make all cells in same row match cell formatted with fill color | Excel Discussion (Misc queries) | |||
| I need to make cell a1 on sheet 2 ALWAYS = a1 on sheet 1 | Excel Worksheet Functions | |||
| How to make columns in one sheet match columns from another sheet | Excel Discussion (Misc queries) | |||
| Using VB to change sheet name to match cell contents | Excel Programming | |||
Threaded Mode
