help keeping the worksheet names within formula

  • Thread starter Thread starter lamaloh
  • Start date Start date
L

lamaloh

I am working with 'weekly' worksheet tabs and want to keep the name o
the tab
for example July1-8 within the formula for each box. Any suggestions
 
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("fi
lename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

will get the sheet tab name
 
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

Scrabble Value calculation for Welsh words 0
How to copy & paste a worksheet but change 1 bit of the formula? 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Worksheet Names using Macros 5
scanning whole workbook with many spreadsheets 1
Sumif to multiple tabs 1
AutoFill Changing Wrong Value 6
VLOOKUP formula for multiple worksheets 4

Back
Top