Trying to get excel to auto fill a series of fields

debi7405 · Apr 16th, 2002, 04:49 PM

I have a database of customer names, addresses, citys and a field for customer notes. They are linked by individual customer numbers I have to find 40-50 customers per day and put them into a worksheet manually. I was wondering if there was a way for excel to fill in the customer fields based on their customer number. So if I enter a number in the cust ID field, that it will find that customer in the database and fill in the rest of the information for me. I have done this in file maker, rather quickly, but for some reason I am excel-dense.

Thanks in advance

Debi

brettvba · Apr 16th, 2002, 04:51 PM

you could use vlookup formulas or design some code if u can vba

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 04:49 PM	#1
debi7405 New Member Join Date: Apr 2002 Location: Debi Posts: 1	I have a database of customer names, addresses, citys and a field for customer notes. They are linked by individual customer numbers I have to find 40-50 customers per day and put them into a worksheet manually. I was wondering if there was a way for excel to fill in the customer fields based on their customer number. So if I enter a number in the cust ID field, that it will find that customer in the database and fill in the rest of the information for me. I have done this in file maker, rather quickly, but for some reason I am excel-dense. Thanks in advance Debi

Apr 16th, 2002, 04:51 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	you could use vlookup formulas or design some code if u can vba