Hi, how do you make MS Excel automatically generate a set of values when you enter in another value.
I'll explain it in a simpler way
Let's say I have a Customer ID field on a sheet along with a address and name field.
What I need it to do is when I enter in a Customer ID in that sheet it should automatically generate that customers name and address to their respective fields in that sheet.
Which I am assuming requires some kind of database function in excel.
How would I go about doing this?
I'll explain it in a simpler way
Let's say I have a Customer ID field on a sheet along with a address and name field.
What I need it to do is when I enter in a Customer ID in that sheet it should automatically generate that customers name and address to their respective fields in that sheet.
Which I am assuming requires some kind of database function in excel.
How would I go about doing this?