+ Reply to Thread
Results 1 to 3 of 3

Dynamic worksheet reference in formulas

  1. #1
    Registered User
    Join Date
    09-29-2008
    Location
    Toronto
    Posts
    2

    Dynamic worksheet reference in formulas

    I have a spreadsheet that contains many worksheets, each containing sales information for each day of the month, labelled 1, 2, 3, etc. I'm trying to create a daily summary report that will take information from a particular sheet and display it on a separate sheet. My non-dynamic formula is:

    ='28'!$C$32/1000

    Where '28' refers to the sheet with the information for the 28th day of the month.

    Is it possible to have Excel determine what yesterday's date was (i.e. 28) and use that in the worksheet reference portion of the formula? I'm trying to accomplish this all in functions rather than VBA or macros, if possible.

    Thanks in advance for your help.
    Dave.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Welcome to the forum.

    Perhaps =INDIRECT(DAY(TODAY() - 1) & "!C$32") / 1000
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-29-2008
    Location
    Toronto
    Posts
    2
    Thanks shg, glad to be here.

    Fantastic! That did the trick - you're a genius.
    Have a great week!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Reference to worksheet name using cell value
    By cowasaki in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2008, 09:41 AM
  2. vlookup dynamic reference
    By tknutsen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2008, 08:40 PM
  3. Creating reference to array which has range defined in a seperate worksheet
    By cdrwolfe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2008, 09:02 PM
  4. Formula Reference Cells & Ungroup worksheet
    By nicolachen in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-21-2007, 07:16 PM
  5. Reference cells in a different worksheet
    By larrywsmith in forum ExcelTip.com Feedback / Comments / Suggestions
    Replies: 0
    Last Post: 07-20-2007, 11:56 AM

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