+ Reply to Thread
Results 1 to 4 of 4

Return data from 4 columns in another sheet by inputting a date

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Return data from 4 columns in another sheet by inputting a date

    Hi All,
    I'm trying to work out how to return data from 4 columns in one worksheet depending on what I input into a cell in another worksheet (same workbook)
    Essentially I want the user to be able to input a date and for the 4 columns below that date (in another worksheet) to be displayed.
    There are 14 dates involved so I can't just use embedded if formulas.
    Any help would be greatly appreciated.
    I have attached an example file to assist.
    In 'Daily Roster'!, I'd like the user to type in the date in B1 and then the roster from 'Cat A'! to return the values I have input there.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,990

    Re: Return data from 4 columns in another sheet by inputting a date

    try this, copied down and across...
    =INDEX('Cat A'!$L:$CG,ROW()+3,MATCH('Daily Roster'!$B$1,'Cat A'!$L$4:$CG$4,0)+COLUMN(A1)-1)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-10-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Return data from 4 columns in another sheet by inputting a date

    Thanks FDibbins,
    Much appreciated.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,990

    Re: Return data from 4 columns in another sheet by inputting a date

    Happy to help and thanks for the feedback

+ 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. Replies: 0
    Last Post: 04-30-2013, 06:16 AM
  2. Inputting data in to one sheet that writes back to master data sheet
    By mackem1979 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2013, 01:21 PM
  3. [SOLVED] Match 2 columns on one sheet to two columns on another sheet and return one value
    By ksienerth00 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2012, 01:50 PM
  4. Replies: 0
    Last Post: 09-17-2012, 06:28 AM
  5. Locking cell after inputting data in selected columns
    By shaunkaz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2007, 07:23 PM

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