+ Reply to Thread
Results 1 to 2 of 2

Restrict to one value per row

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    Oregon
    MS-Off Ver
    Excel 2013
    Posts
    1

    Unhappy Restrict to one value per row

    I'm not sure if this is possible.

    For example,

    I have four columns and rows that I'm working with. Each row should only have one value in each columns. ie. A2 and B2 can't both contain values. I'd like only to have one value per row. Is there a way to set a macro that will automatically delete the ..say B2 if there is already a value in A2?

    I hope this make sense.

    Heather

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Restrict to one value per row

    Here is the macro and in the attached workbook, you have a working example.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ 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. Restrict rows
    By Fineline in forum Excel General
    Replies: 5
    Last Post: 05-24-2013, 06:30 PM
  2. restrict with rules
    By mqdias in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2006, 12:02 PM
  3. restrict users
    By Restricted user access for exel workbook in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-15-2006, 11:30 AM
  4. [SOLVED] restrict scrolling
    By KimR.Hammel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2005, 03:05 PM
  5. [SOLVED] Restrict Highlighting?
    By David in forum Excel General
    Replies: 4
    Last Post: 07-29-2005, 05:05 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