+ Reply to Thread
Results 1 to 2 of 2

If Cell-X not equal to any cell in Range-Y, then enter value into Range-Y

  1. 10-14-2019, 01:19 AM #1
    mruu
    mruu is offline
    Registered User
    Join Date
    06-23-2019
    Location
    Sydney, Australia
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    48

    If Cell-X not equal to any cell in Range-Y, then enter value into Range-Y

    My code works beautifully. But I want to put a condition in to prevent any double up entries.

    Please Login or Register  to view this content.
    I did try to incorporate a second MyCell/Range but it got extremely confusing and I feel it should just be a simple solution (that I can't figure out ).
    Reply With QuoteRegister To Reply
  2. 10-14-2019, 01:58 AM #2
    mruu
    mruu is offline
    Registered User
    Join Date
    06-23-2019
    Location
    Sydney, Australia
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    48

    Re: If Cell-X not equal to any cell in Range-Y, then enter value into Range-Y

    Got it!

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. equals cell from a range if a specific cell is equal
    By kieranlavin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2019, 03:12 PM
  2. locking and unlocking range of cell automatically when enter data in cell
    By pchrakesh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2019, 08:57 AM
  3. [SOLVED] If cell matches Cell Range than enter text in another cell
    By BOB MUSE in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-20-2018, 09:32 AM
  4. check for match of cell to range of cells only if another cell is equal to X
    By rfigueroa1976 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-25-2015, 07:51 PM
  5. if a range of celll eg b1 to b20 90.1 enter and and cell range c1 to c20 ok then change
    By sspreyer in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-17-2013, 03:42 PM
  6. Sum cells in a range based between two equal cell values in another range
    By sshone1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2013, 08:12 AM
  7. [SOLVED] Cond. formatting a column/Range, highlight cell in column/range if equal to specific text
    By DFrank231 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 03:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1