Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 26th 05, 07:36 PM
jbtenor1
 
Posts: n/a
Default Tab Name Shown In Another Sheet's Cell

Is it possible to pull the tab name from another sheet within the same
workbook and show it in a cell?

  #2   Report Post  
Old October 26th 05, 08:52 PM
bill k
 
Posts: n/a
Default Tab Name Shown In Another Sheet's 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


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=479563



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Copying the same cell from different sheets Steve Excel Discussion (Misc queries) 2 March 16th 05 07:43 PM
One cell from several sheets to one column Kel Excel Discussion (Misc queries) 5 February 17th 05 02:33 AM
comments in cell shown halfsized Roland Excel Discussion (Misc queries) 0 January 25th 05 08:39 PM


All times are GMT +1. The time now is 05:59 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017