Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy Worksheet Tab Name into a cell address
I'm creating an Excel Book with several worksheets. As with a lot of the
information on the woorksheets I am trying to automate the data entry to cut down on user input and/or duplication. I would like to use worksheet name, enetered on the 'Tab', within one of the worksheet cell adresses. Can anyone help? |
#2
|
|||
|
|||
Hi
Try the following formula (note: the workbook has to be saved before it'll work) =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1),1)) Copy and paste the formula as it is - on a single line. -- Andy. "Andy" wrote in message ... I'm creating an Excel Book with several worksheets. As with a lot of the information on the woorksheets I am trying to automate the data entry to cut down on user input and/or duplication. I would like to use worksheet name, enetered on the 'Tab', within one of the worksheet cell adresses. Can anyone help? |
#3
|
|||
|
|||
Excellent, it works without any problems.
"Andy B" wrote: Hi Try the following formula (note: the workbook has to be saved before it'll work) =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1),1)) Copy and paste the formula as it is - on a single line. -- Andy. "Andy" wrote in message ... I'm creating an Excel Book with several worksheets. As with a lot of the information on the woorksheets I am trying to automate the data entry to cut down on user input and/or duplication. I would like to use worksheet name, enetered on the 'Tab', within one of the worksheet cell adresses. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
How do I link the worksheet tab to a cell in the worksheet? | Excel Worksheet Functions | |||
copy a cell to another worksheet? | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions |