hi everybody.
i need some advice in excel.
can anybody tell me how the get the name of a sheet as a string?
i have a formula using the name of a sheet and i dont want to leave it hardcoded.
ex:
=IF(ISERROR(MATCH(_02.07.2009!B6;(OFFSET(_01.07.2009!$B$5;0;0;COUNTA(_01.07.2009!$B:$B)-1;1));0));1;0)
i need that dates as variables. those are the names of the sheets im using
i have no idea for what exactly i have to keep looking so i would really be glad if you can help me.
thank you very much
Bookmarks