+ Reply to Thread
Results 1 to 3 of 3

Auto-populating formula's and Data Validation based on 1 cells data validation result

  1. #1
    Forum Contributor
    Join Date
    05-11-2020
    Location
    Kansas City
    MS-Off Ver
    Office 365
    Posts
    195

    Auto-populating formula's and Data Validation based on 1 cells data validation result

    I am trying to have a formula populate into Column A and a data validation populate in column J based on the data validation list that is selected in column M. I have highlighted the areas (tab "Jobs") that have the correct formula in column A and the correct data validation in column J. I would like to be able to select my Press- in column M and have the correct formula automatically populate into column A and the Print Mode data validation to populate into column J. I'm not sure if this is possible, but if it is I would appreciate any help in figuring it out.

    Thank you in advance,
    Adam
    Attached Files Attached Files
    Last edited by Newtonus_Prime; 12-22-2023 at 02:51 PM. Reason: Made a new sample

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,696

    Re: Auto-populating formula's and Data Validation based on 1 cells data validation result

    C2:C5 do not have formula only #N/A
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    05-11-2020
    Location
    Kansas City
    MS-Off Ver
    Office 365
    Posts
    195

    Re: Auto-populating formula's and Data Validation based on 1 cells data validation result

    Sorry about that. I have updated the file.

    Thanks,
    Adam

+ 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. Multi-select from data validation isn't working with auto-assigning data validation
    By iPenguin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2017, 12:37 PM
  2. [SOLVED] Populating Cells via Data Validation
    By windtalkers26 in forum Excel General
    Replies: 9
    Last Post: 01-29-2016, 01:03 AM
  3. Data Validation List based on formula result
    By dancing-shadow in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2015, 11:49 AM
  4. Auto-Populate cells based on data validation and free-form entry
    By Tawana127 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-17-2013, 02:32 PM
  5. Auto populating of formula with result based on input data and party name
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 02:56 AM
  6. Adding multiple cells based on the result of a data validation cell
    By ronrona96 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-20-2013, 12:19 AM
  7. Populating a Data Validation List based on...
    By orcheon in forum Excel General
    Replies: 5
    Last Post: 04-18-2009, 12:55 AM

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