+ Reply to Thread
Results 1 to 4 of 4

Data Validation based on drop down selection

  1. #1
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Smile Data Validation based on drop down selection

    G'day Gurus,

    Bit of a strange one(for me), not sure if this is entirely possible and googling doesn't seem to have the exact answer I am asking(could be wrong terminology)

    I have a word document, its a warning letter for breach the legislation.

    What I would like to do is take the guess work out of what to write for officers.

    Attached is a quick dirty template
    Drop down menu - Select which piece of legislation(Act 1-3 for temp)
    Possible second drop down with the Section of the Act
    Red Text - Free Text
    Blue Text - Space that will change depending on drop down

    What I would like to do is change the standard text marked in Red based on what Act and section has been selected up the top.

    Is data validation in word a thing that can be achieved or would is it be best to do the letter template in excel.
    Attached Files Attached Files

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Data Validation based on drop down selection

    See, for example: https://www.msofficeforums.com/word-...tml#post120392
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Data Validation based on drop down selection

    Quote Originally Posted by macropod View Post
    Legend, Thank you. I will have a look at the link.

  4. #4
    Registered User
    Join Date
    05-22-2021
    Location
    New York
    MS-Off Ver
    Mac
    Posts
    4

    Re: Data Validation based on drop down selection

    This is perfect 👌🏼

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-14-2018, 11:04 AM
  2. [SOLVED] Data validation drop down with calendar selection
    By dna247 in forum Excel General
    Replies: 5
    Last Post: 08-30-2017, 12:18 PM
  3. Replies: 1
    Last Post: 07-04-2017, 09:00 PM
  4. Updating cells based on selection from drop down list data validation
    By excelstun in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-18-2016, 05:11 PM
  5. Replies: 7
    Last Post: 03-06-2015, 01:53 PM
  6. displaying list based on data selection in drop down of data validation
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-16-2014, 12:51 AM
  7. [SOLVED] Updating cells based on selection from drop down list data validation
    By jingles9 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2013, 02:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1