Results 1 to 11 of 11

sheet name extraction

Threaded View

  1. #1
    Registered User
    Join Date
    07-06-2009
    Location
    zürich, switzerland
    MS-Off Ver
    Excel 2003
    Posts
    36

    sheet name extraction

    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
    Last edited by f_mayr; 07-07-2009 at 05:55 AM. Reason: rules

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1