|
|
|
|
| Author |
|
|
Targa, Panamera Turbo
Join Date: Aug 2004
Location: Houston TX
Posts: 22,366
|
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?
__________________
Michael D. Holloway https://simple.m.wikipedia.org/wiki/Michael_D._Holloway https://5thorderindustry.com/ https://www.amazon.com/s?k=michael+d+holloway&crid=3AWD8RUVY3E2F&sprefix= michael+d+holloway%2Caps%2C136&ref=nb_sb_noss_1 |
||
03-16-2006, 07:02 PM
|
|
|
Moderator
|
I think with the Forms.Listbox Method
__________________
Don Plumley M235i memories: 87 911, 96 993, 13 Cayenne |
||
|
03-16-2006, 07:17 PM
|
|
|
Registered
Join Date: Mar 2006
Location: PNW
Posts: 39
|
Been to: http://www.mrexcel.com/ ?
|
||
|
03-16-2006, 08:26 PM
|
|
|
Registered
|
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. |
||
|
03-17-2006, 01:53 AM
|
|
|
Targa, Panamera Turbo
Join Date: Aug 2004
Location: Houston TX
Posts: 22,366
|
my e-mail is mhollowa@nch.com. Thanks.
__________________
Michael D. Holloway https://simple.m.wikipedia.org/wiki/Michael_D._Holloway https://5thorderindustry.com/ https://www.amazon.com/s?k=michael+d+holloway&crid=3AWD8RUVY3E2F&sprefix= michael+d+holloway%2Caps%2C136&ref=nb_sb_noss_1 |
||
|
03-20-2006, 02:16 PM
|
|
1987 Porsche Carrera 3.2 
1983 Porsche 911 SC Targa 3.0
