drop-down list and auto fill

  • Thread starter Thread starter erin
  • Start date Start date
E

erin

Hi,
I've got a customer list I want to have available for
users in a worksheet. When users select a name from the
drop-down list, I need the remaining contact info to fill-
in in subsequent rows. Customer info goes into 4 rows,
in merged cells A-E.

Creating a drop-down list of names using data validation
and then having the remaining contact info available
within custom fill lists works, in so far as is goes.
The problem I have with this approach is it's 1) not
intuitive 2) not always easy to grab the fill handle.

Is there an easy way to do what I want using existing
Excel functions or do I need to get into some VBA
programming?

FYI - The customer list does not currently exist in any
excel workbook (or anywhere else I can import it from).

Convinced there's a better way and looking for a little
guidance,

Erin TIA!
 
If you can orient it to columns instead of rows, then you can use Data Filters to easily select the data. Say Column 1 is Company Name, column 2 is Contact Name, column 3 is Address and so forth. Data, Auto Filter creates the Company Name drop down box for you and the rest of the company name appears in the row when you select it from the drop down list

Hope that helps.
 
Back
Top