Escape Character

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

Attempting to reference another worksheet within a cell;
Sense the worksheet name is dynamic I want to use a
formula to reference the worksheet name ...'tab[1-
50]'$c$3...the items in bracket will get its number from
another cell.
 
=INDIRECT(C1&"!A1")

, where tab name is in C1. So if C1 = "Sheet2", the formula returns
Sheet2!A1.

Rgds,
Andy
 
Thank you! What about copying a Tab name into a cell?...I
want to automatically copy the current Tab's name into a
cell.
 
This formula will return the tab name in any of its cells -

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

The file must be saved first or it'll return an error.

HTH,
Andy
 
Back
Top