Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I reference tab labels from a worksheet in a cell in the wb
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Text Cell to Reference a Worksheet Name | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Reference a cell on another worksheet in the same spreadsheet file | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions |