| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rename worksheet based on contents of a cell in different workshee
I have three worksheets within a workbook. The three worksheets are named
"Account Info" "sep 27,2006" "lists" I would like to automatically rename the second worksheet "sep 27, 2006" based on the contents of cell B6 in the "Account Info" worksheet. The contents of B6 will be a date in the above format. The workbook is a template. How do I do that? I figure I need to right-click the worksheet tab and enter vba code into the Visual Basic Editor but what is the code? Can I copy and paste the code or is that not possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| *How can you rename a tab based on a cell value | Excel Discussion (Misc queries) | |||
| Rename Multiple Excel Workbooks based on cell contents | Excel Discussion (Misc queries) | |||
| total two cells from one worksheet to one cell in another workshee | Excel Discussion (Misc queries) | |||
| new worksheet and rename from cell contents macro | Excel Worksheet Functions | |||
| How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) | |||
Threaded Mode
