| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Based new sheet names on cell value
Private Sub Workbook_NewSheet
Need each sheet name to have same prefix then end with cell value. Prefix: "Jeremy " Suffix: Value in cell e2: 6/23/2009 For end result, subtract one from date given in e2. End Result: Jeremy Mon 6-22 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change sheet names based on cell contents | Excel Programming | |||
| Dynamic list based on sheet names | Excel Programming | |||
| Cell names = sheet names | Excel Worksheet Functions | |||
| hyperlink to sheet name where sheet names=cell content | Excel Programming | |||
| Create seperate xls files with names based on cell text | Excel Programming | |||
Linear Mode
