+ Reply to Thread
Results 1 to 2 of 2

Mandatory Cells

  1. #1
    Registered User
    Join Date
    08-24-2017
    Location
    Exeter, England
    MS-Off Ver
    2016 - Professional Plus
    Posts
    21

    Mandatory Cells

    Hi All,

    I have been looking for a solution for this for a few hours now and I am getting nowhere with Google/Trial and Error so I am hoping someone more knowledgable can point me in the right direction.

    I have a workbook being sent to multiple offices to gather information from the office manager, unfortunately they are frequently failing to complete all the required information and causing multiple emails back and forth to complete the form.

    I am looking for a way to force the completion of columns B-H if there enter any value in column A. I have found solutions to similar issues online but have not been able to adapt any of them to work the way required.

    For example if A2 contains a value then B2 - H2 should all contains values or the workbook should fail to close/save.

    It is possible that multiple rows will be completed and as such need to also have mandatory cells. For example if Cells A2, A3, A4 all contain values then B2 - H4 should also contains values.

    The entries in column A should be contiguous.

    Can anyone advise if this is possible? has anyone come across a similar problem/solution?

    Thanks

    Rich

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,891

    Re: Mandatory Cells

    Use data validation in Column A, if counta from B:H is 7 then only it will accept the entry in Column A
    Means you have enter the data in B to H before enter the data in Column A
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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. VBA - mandatory cells in excel
    By bees2cute in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2016, 09:02 AM
  2. How can I make multiple cells mandatory if new rows are used with some cells left blank?
    By markbarnett in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-11-2015, 07:06 AM
  3. Mandatory cells if another is filled
    By jdixon825 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2014, 10:32 PM
  4. Mandatory field required message when user skips mandatory fields
    By Bharathi27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 05:12 AM
  5. Mandatory Cells
    By MYQ in forum Excel General
    Replies: 7
    Last Post: 10-12-2012, 02:16 PM
  6. Mandatory cells
    By john.mk in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-25-2010, 11:03 PM
  7. Mandatory Cells
    By Mel1221 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-05-2006, 05:10 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