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!
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!