Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using worksheet name
Is there a way to use the name of a worksheet in a formula? I would like to use the 'if' function and have one of the criteria be the name of the worksheet. Thanks -- Deborah J Doyle ------------------------------------------------------------------------ Deborah J Doyle's Profile: http://www.excelforum.com/member.php...o&userid=33526 View this thread: http://www.excelforum.com/showthread...hreadid=533220 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using worksheet name
The following formula will return the name of the worksheet on
which it appears. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1),1)+1,33) Note that the file must have been saved to disk for the formula to work. Also, leave the "filename" text intact -- do not substitute the actual file name -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Deborah J Doyle" <Deborah.J.Doyle.26c0pa_1145148602.2042@excelfor um-nospam.com wrote in message news:Deborah.J.Doyle.26c0pa_1145148602.2042@excelf orum-nospam.com... Is there a way to use the name of a worksheet in a formula? I would like to use the 'if' function and have one of the criteria be the name of the worksheet. Thanks -- Deborah J Doyle ------------------------------------------------------------------------ Deborah J Doyle's Profile: http://www.excelforum.com/member.php...o&userid=33526 View this thread: http://www.excelforum.com/showthread...hreadid=533220 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using worksheet name
THANKS!! the formula worked perfectly! -- Deborah J Doyle ------------------------------------------------------------------------ Deborah J Doyle's Profile: http://www.excelforum.com/member.php...o&userid=33526 View this thread: http://www.excelforum.com/showthread...hreadid=533220 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |