![]() |
#1
|
|||
|
|||
![]()
Hi
I am more of an excel user but i have a form to update at work and it requires the creationof drop down lists. I finally figured out how to create the first one but now what I need to do is this: when I select an option from the 1st drop down I need it to give me optiopns for the 2nd drop down. For example the 1st drop down would have business units so wheni select a business unit i want it to show me the breakdown of individual departments ie legal, benefits, consultancy etc, but if I pick another it might have different departments. I dont want to use macros if I can help it becasue I am not confident with them. Any help please ![]() |
#2
|
|||
|
|||
![]()
Hi
If you are more familiar with Excel then have you considered creating the drop down's in Excel then embedding the Excel worksheet in your Word document. You can then double click the Worksheet in your Word document to make your selections then click out side the worksheet in your Word document to deactivate the spreadsheet. If you need any help with this then let me know. Hope this helps. Tony |
#3
|
|||
|
|||
![]()
Thanks for coming backl to me. I am not sure how to do this - would you mind helping?
|
#4
|
|||
|
|||
![]()
Hi
Follow this link. If you need further help then come back to me on the forum. http://office.microsoft.com/en-gb/wo...20810.aspx#BM4 Tony |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dependent drop down lists | bobbych | Word | 1 | 02-08-2013 04:38 PM |
Locking Documents and Drop-Down Lists | Andrew H | Word | 2 | 11-04-2012 02:59 PM |
![]() |
Maureen | Excel | 1 | 11-10-2011 08:11 AM |
Dependent drop down lists in Word 2007 | benbenasc | Word VBA | 0 | 08-24-2011 06:34 AM |
Drop Down Lists | Browett | Excel | 0 | 12-19-2005 04:20 PM |