Consulting

Results 1 to 3 of 3

Thread: Solved: How to auto populate data from Worksheet

  1. 07-29-2009, 04:43 AM #1
    winxmun
    winxmun is offline
    VBAX Contributor
    Joined
    Sep 2007
    Posts
    129

    Solved: How to auto populate data from Worksheet

    How to extract/ link data from Sheet1 to Sheet2 whenever user input cell B1 & C1?

    Eg. If user input 1Q/07 at B1, Excel to auto search 1Q/07 from Sheet1 & auto populates the data (Item 1 – Item 8). Likewise for C1.

    Pls refer to sample file attached. tks a lot!
    Reply With Quote Reply With Quote
  2. 07-29-2009, 05:44 AM #2
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Try this

    =HLOOKUP(Sheet2!B$1,Sheet1!$1:$10,ROW()-1,FALSE)
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
  3. 07-29-2009, 05:53 PM #3
    winxmun
    winxmun is offline
    VBAX Contributor
    Joined
    Sep 2007
    Posts
    129
    Yes! It works perfectly! Thank you so much...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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