| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using information from one worksheet, to rename inserted worksheet
I am trying to automate a worksheet as follows :
From a register of information (sheet 1) Insert a new worksheet, move it into the position immediately right of sheet 1 (making it the 2nd sheet within the workbook), then rename the sheet using a number in a cell on Sheet 1. What I am ultimately trying to achieve is as numbers are added to the list on the register sheet this information is then used to rename new worksheets as they are added. If any one can help I would appreciate it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| how do i bring information from one worksheet to another in excel. | Excel Worksheet Functions | |||
| when copying a worksheet to a new one, some of the information do. | Excel Discussion (Misc queries) | |||
| How do i auto rename a worksheet to be the same filename as save f | Excel Worksheet Functions | |||
Linear Mode
