excel front end

[Guest]

can anyone offer help on how todreate a front end for excel. I have multiple
sheets and want to creat a sheet where users sellect from a drop down list
one name. Depending on the name they select they will then have certain
information displayed, different for each informaton for each name.
any help very much appreciated.
thanks, mienda

 

[Debra Dalgleish]

There's a sample file on my web site that uses Data Validation and
VLookup to complete an order form. You could use the same technique for
your worksheet:

http://www.contextures.com/excelfiles.html

Look for the heading: Order Form (DataValOrder.xls)