Is it possible to pull the tab name from another sheet within the same
workbook and show it in a cell?
Is it possible to pull the tab name from another sheet within the same
workbook and show it in a cell?
you need to get the tab name in a cell in the original sheet first
use the formula in for example cell B2
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
then on the other sheet you can refer to............... =sheet1!B2
Greetings from New Zealand
Bill Kuunders
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks