Copy Worksheet Tab Name into a cell address

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Excellent, it works without any problems.

Andy B said:
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 said:
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?
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying row 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
shorten worksheet name 1
Worksheet tab name 12
Name a worksheet tab based on the value in a cell. 1
Copy Cells from multiple Worksheets in same workbook. 2
Linking Tab/worksheet names to a worksheet cell 3
Cannot copy worksheet to another file 2

Back
Top