Results 1 to 2 of 2

Thread: Can we select one value from list & have a series of values populated from a another

  1. #1

    Can we select one value from list & have a series of values populated from a another



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi


    I'm new here and have only a little knowledge on Excel.. and trying to get good hold on it..


    I have database where.. The first sheet have got 4 rows ( dashboard kind of a setup ) entered and when we hit save.. it will send this data into the second sheet into 4 columns..


    Sheet 1:


    OrderID: 3432
    Salesman: jack
    Product no: 920
    Qty: 9


    SAVE - Button ( when we hit on this the data is saved into the next sheet )




    Sheet 2:


    OrderID Salesman Productno Qty
    3432 Jack 920 9




    Can I enter the orderId on sheet one and have rest of the data populated if its already existing in the sheet2?


    Like orderID can be a list from which when I select 3432 it should bring up Salesman, Productno and Qty related to that which was saved already..




    If I can get a lead I will try working on it.. Please give me your suggestions.. Thank you

  2. #2
    When you say saved, do you mean separate workbooks, or separate cells on Sheet1? If the latter, what is the layout?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •