Pelican Parts Forums

Pelican Parts Forums (http://forums.pelicanparts.com/)
-   Off Topic Discussions (http://forums.pelicanparts.com/off-topic-discussions/)
-   -   Another .xls Question (http://forums.pelicanparts.com/off-topic-discussions/271974-another-xls-question.html)

M.D. Holloway 03-16-2006 07:02 PM
Another .xls Question
 
How do you do a drop down, have the selection trigger the population of another cell to be filled in with several pre-assigned sentences. Then have those show up into a printable report?

I know Access can do this but I need Excel to do this as well. Any ideas?

Don Plumley 03-16-2006 07:17 PM
I think with the Forms.Listbox Method

Bryan A. 03-16-2006 08:26 PM
Been to: http://www.mrexcel.com/ ?

Paco Anton 03-17-2006 01:53 AM
You need to use VLOOKUP or CHOOSE to select the sentences based on the menu options and CONCATENATE to create the report.

Send me an email and I'll attach you an example.

M.D. Holloway 03-20-2006 02:16 PM
my e-mail is mhollowa@nch.com. Thanks.


All times are GMT -8. The time now is 12:02 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0
Copyright 2025 Pelican Parts, LLC - Posts may be archived for display on the Pelican Parts Website


DTO Garage Plus vBulletin Plugins by Drive Thru Online, Inc.