+ Reply to Thread
Results 1 to 4 of 4

Quick and Dirty : User selects from dropdown (sht1)...macro populates data from (sht2)

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    NYC
    MS-Off Ver
    Excel 2003/7
    Posts
    6

    Quick and Dirty : User selects from dropdown (sht1)...macro populates data from (sht2)

    As always...thank you for all of your wisdom and knowledge. Greatly appreciated.


    Have a roadblock on an excel workbook, and am asking for any pointers/assistance. Thank you in advance.

    In the attached wrbk, in Sheet1, user will use the dropdown in cell A3 to select the appropriate month. Depending on the month selected, the data found in Sheet2 will be populated appropriately in Sheet1. The workbook currently has the data for the month of Jan.

    Is this a good candidate for vba/macros?

    Thanks again...feel free to post comments/questions. Thank you.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-27-2012
    Location
    London
    MS-Off Ver
    Excel 2007-2010
    Posts
    59

    Re: Quick and Dirty : User selects from dropdown (sht1)...macro populates data from (sht2)

    Hi Joecruz749,

    Why not use a vlookup formula?

    In cell D4 insert
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Break_Point

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Quick and Dirty : User selects from dropdown (sht1)...macro populates data from (sht2)

    No need for a macro. Just stick with the VLOOKUP() function. See attached.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    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: Quick and Dirty : User selects from dropdown (sht1)...macro populates data from (sht2)

    A simple index/match will give youwhat you need, you dont need VBA. In D4, copied down and to H...
    =INDEX(Sheet2!$A$1:$G$13,MATCH(Sheet1!$A$3,Sheet2!$A$1:$A$13,0),MATCH(Sheet1!C4,Sheet2!$A$1:$G$1,0))
    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 to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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