http://www.cpearson.com/excel/excelF.htm#SheetName
--
Brevity is the soul of wit.
"Lee" wrote:
Depending on the result of a test - =IF(APR!H520,... I want to insert the
name of the sheet into a cell on another sheet and use it to automatically
insert the last day of the month in a cell.
E.g. on sheet APR, if H52 is greater than 0, the sheet CLAIM B10=APR.
Then if B10 =APR then B11 contains 30 April 06
Can this be done and if so can someone point me in the right direction please?
Cheers,
Lee