Word - Prepopulate text based on Drop Down selection

[StephanieAnn]

Hi!

I'd like to setup a Word document that is based on what was selected from a drop down. I can do it in Excel if necessary.

For example:

If I select from the drop down: "Medical", I'd like to have a new statement come up with "Any Discounts" then another drop down for "Yes" or "No"

I tried VBA, but that's way more advanced than what I can handle.

I need more of an IF/Then situation:

IF(C1 = "Supplement" then C2 = "Any Discounts")
IF(C2 = "Any Discounts" then C3 = "Yes" or "No") I don't have a false scenario.
IF(C1 = "Short Term" then C2 = "Duration" AND C4 = "Effective Date")
IF(C2 = "Duration" then C3 = "30" "60" "90" AND C5 = free form)

I don't know if this makes any sense.

 

[ER_Neha]

Hello For Dynamic listing you will need to name the cells together under a group (my terminology might not be perfect). Please refer to the xl2bb below for better understanding. I hope it helps.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Supplement	AnyDiscount	Duration			Supplement	AnyDiscount	Yes
2	Short Term	Yes	30			Data Validation->list->A1:A2		Data Validation->list->=INDIRECT(G1)
3		No	60
4			90
5
6		cells B1:B2 named as AnyDiscount
7		cell C1:C2 named as Duration
Sheet1

Cell Formulas
Range	Formula
G1	G1	=IFS(F1=A1,B1,F1=A2,C1)

Cells with Data Validation
Cell	Allow	Criteria
F1	List	=$A$1:$A$2
H1	List	=INDIRECT($G$1)

 

[StephanieAnn]

Really would just like a way to select a "product" then the specific fields under that product accumulate.
For Example: I select Doctor Toe, I want these fields to appear only when I select Doctor Toe. If I select Doctor Nose, these fields should appear.

Doctor Toe
--Type of Service:
--Ingrown Toenail
--Sprain
--Assistant:
--Carol Shoe
--Pail Nolish

Doctor Nose
--Type of Service:
--Plastic Surgery
--Fracture
--Performed by:
--David Nasal
--Doctor Nose

This all might need to be done in Access.