+ Reply to Thread
Results 1 to 2 of 2

Only allow certain data in a cell depending on value of another cell

Hybrid View

  1. #1
    Registered User
    Join Date
    02-01-2017
    Location
    Suffolk, England
    MS-Off Ver
    2010
    Posts
    2

    Question Only allow certain data in a cell depending on value of another cell

    Hi All,

    I am trying to find a way to disallow the entry of certain data depending on the value of another cell. I have a list of 13 items to choose from AD001, AD002 etc in one column and 4 workflows: 30, 75, v4 and v5 to choose from to populate the second column. We only use 12 at a time and for workflows v4 and v5 we aren't allowed to use AD013 and for 30 and 75 we're not allowed to use AD003. Is there a way to prevent entry of AD013 if the workflow is either v4 or v5 and same for AD003 if the workflow is 30 or 75.

    Thanks you in advance,

    Lucy

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Only allow certain data in a cell depending on value of another cell

    Duplicate thread...

    http://www.excelforum.com/showthread.php?t=1172197
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Force data entry into a cell depending on value of a different cell
    By hammer68 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2015, 11:55 AM
  2. copy a cell multiple times depending on cell value starting on a specific cell
    By weritadiojomiel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2013, 05:25 AM
  3. [SOLVED] Pull data from a cell depending on another cell's value
    By poptart141 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2013, 03:12 PM
  4. [SOLVED] Data Validation in cell X depending upon the value in cell Y?
    By gjfreem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2012, 12:45 PM
  5. Data Validation Depending on Another Cell
    By gilbert in forum Excel General
    Replies: 2
    Last Post: 03-22-2011, 02:35 AM
  6. Replace cell content- depending on other cell data
    By DEVIL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-06-2009, 07:07 PM
  7. Sum of the cell values depending on the data from other cell
    By IamDBest in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2007, 02:14 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