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