Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Name
Hi All,
I am a first timer. So bare with me. I would like to get the workbook name and place it in a cell in the worksheet. This is what I do. I copy a worksheet, when it creates a copy it gives it the name of the worksheet it was copied from and it adds a "(2)" at the end of the name. I want to take this name and place it in a cell in the workbook, and if the name of the sheet is changed I want it to reflect the change. Could some one help. Thanks Peter |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Name
I want to take this name and place it in a cell in the workbook, and if the
name of the sheet is changed I want it to reflect the change One way, from a posting by Richard Schollar: =REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"") The workbook must have been saved beforehand -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Name
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,99)
If this post helps click Yes --------------- Jacob Skaria "_Pete_" wrote: Hi All, I am a first timer. So bare with me. I would like to get the workbook name and place it in a cell in the worksheet. This is what I do. I copy a worksheet, when it creates a copy it gives it the name of the worksheet it was copied from and it adds a "(2)" at the end of the name. I want to take this name and place it in a cell in the workbook, and if the name of the sheet is changed I want it to reflect the change. Could some one help. Thanks Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) |