Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

Drop-down list & auto-population of cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TC - 21 Dec 2005 03:03 GMT
Hi,

I am trying to create a form where a user would select from a list of
different products. Depending on the users product selection, certain other
information may need to be populated.  How can I make it so the drop-down
list auto populates other cells (i.e. customer name field, location, etc.)
after certain products are selected.
Max - 21 Dec 2005 03:16 GMT
Try Debra's "Create an Order Form" example at her:
http://www.contextures.com/xlOrderForm01.html
which covers what you're after (DV & Vlookup to populate)
(There's also a sample file to download)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
> Hi,
>
[quoted text clipped - 3 lines]
> list auto populates other cells (i.e. customer name field, location, etc.)
> after certain products are selected.
TC - 21 Dec 2005 03:49 GMT
Great info.. Thank you so much!

> Try Debra's "Create an Order Form" example at her:
> http://www.contextures.com/xlOrderForm01.html
[quoted text clipped - 17 lines]
> > list auto populates other cells (i.e. customer name field, location, etc.)
> > after certain products are selected.
Max - 21 Dec 2005 04:21 GMT
You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
> Great info.. Thank you so much!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.