Can we make one column primary & when selected get the rest of the values populated

[balu.soln4biz]

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

[Bernie Deitrick]

This workbook will allow you to choose an orderID from the existing list, using the drop-down on cell B1, and you can edit the values and overwrite the existing data, or you can enter a new value, and add it to the database....

Book2.xlsm

[balu.soln4biz]

Thanks for the reply Deitrick,

Can we have the same functionality for multiple values?

would I be able to enter multiple order ID's with other details and add them all to the database?

I'm only trying to match my functionality to the document you posted.

Thank you!

[Bernie Deitrick]

You need to better explain what you want to do....