Thread: how do I reference tab labels from a worksheet in a cell in the wb
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default how do I reference tab labels from a worksheet in a cell in the wb
"keri" wrote:
Trying to reference just the name of another worksheet (tab)
within the same workbook and do not want to do it
in the header/footer - trying to reference it in a cell.

Do you mean something like this ?

In Sheet1,

In A1: =Sheet2!A1

A1 will return the contents of A1 in Sheet2,
or return zero if Sheet2's A1 is empty

We could also use in A1:
=IF(Sheet2!A1="","",Sheet2!A1)
for a cleaner look if Sheet2's A1 is empty
(instead of zeros returned)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote