+ Reply to Thread
Results 1 to 3 of 3

Using sheet names as a named range

  1. #1
    Registered User
    Join Date
    01-12-2009
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    28

    Using sheet names as a named range

    Hi. I,m not sure if what I want is possible, but here goes. I have a namd sheet for everyday of the year in a workbook, so jan1 jan2 jan3 etc. I have a stats page which brings together certain pertinent data from those pages, so a formula on the stats page might look like this =sum('jan1'!$m$25:$m$900). What I would like to do is to name each day - jan1 jan2 etc as a named range perhaps date1 date2 etc so that the above formula would then look like =sum(date1!$m$25:$m$900). Is this possible to do, and if so how? Thanks for all and any help Smileyc
    Last edited by smileyc; 02-06-2009 at 05:40 AM. Reason: to flag as solved

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,934

    Re: Using sheet names as a named range

    One way would be the use of INDIRECT

    =SUM(INDIRECT(E5&"!$m$25:$m$900"))

    Where the cell E5 contains the sheet name.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-12-2009
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Using sheet names as a named range

    Andy that is fantastic! Many many thanks.

+ Reply to Thread

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