+ Reply to Thread
Results 1 to 4 of 4

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

  1. 07-16-2013, 01:34 AM #1
    greg19
    greg19 is offline
    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
    Reply With QuoteRegister To Reply
  2. 07-16-2013, 02:27 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    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
    Reply With QuoteRegister To Reply
  3. 07-16-2013, 03:07 AM #3
    greg19
    greg19 is offline
    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.
    Reply With QuoteRegister To Reply
  4. 07-17-2013, 12:10 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

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

    Happy to help and thanks for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inputting data in different columns via input template(sheet) which changes by dropdown.
    By brightoke in forum Excel Formulas & Functions
    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. Automatically Inputting/Transferring Data from a form on one sheet into another sheet?
    By demonfly100 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1