+ Reply to Thread
Results 1 to 3 of 3

take data from one sheet to another depending on date selected.....

  1. #1
    Registered User
    Join Date
    09-28-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    11

    take data from one sheet to another depending on date selected.....

    Hi

    I'm trying to create a speadsheet for work with a formula I don't know how to work.

    My staff enter data every day in to a particular sheet - in this example the sheet is called Historic Daily Data. I want the second sheet, called 'Daily Snapshot', to populate with data from the Historic Daily Data sheet, depending on what date is selected in the drop down list in the Daily Snapshot sheet.

    I've attached an example as I may not have explained it well. Hopefully it makes sense. Obviously the example is the very basics, but the formula required will be the same.

    oh, this test is on my home pc which is excel 2010 but at work we use 2003 so any formulas will need to work on that.

    thanks in advance.

    test.xlsx

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: take data from one sheet to another depending on date selected.....

    Your workbook is set to manual calculation, you might want to change that back. in B2, copy/paste

    =INDIRECT("'Historic Daily Data'!"&ADDRESS(MATCH($B$1,datelist,0)+1,ROWS($B$1:B2)))

  3. #3
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: take data from one sheet to another depending on date selected.....

    You can use VLOOKUP, HLOOKUP, INDEX/MATCH

    =VLOOKUP(B$1,'Historic Daily Data'!$A:$D,MATCH(A2,'Historic Daily Data'!A$1:D$1,0),0)

    =HLOOKUP(A2,'Historic Daily Data'!A$1:D$16,MATCH(B$1,'Historic Daily Data'!A$1:A$16,0),0)

    =INDEX('Historic Daily Data'!B:D,MATCH(B$1,'Historic Daily Data'!A:A,0),ROWS(B$2:B2))

    Use any of them in B2, then copy down.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

+ 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