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. |
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 --- |
All times are GMT +1. The time now is 12:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com