+ Reply to Thread
Results 1 to 2 of 2

VBA to skip formula if criteria doesn't match

  1. #1
    Registered User
    Join Date
    01-15-2019
    Location
    US
    MS-Off Ver
    2007
    Posts
    7

    VBA to skip formula if criteria doesn't match

    I been trying to find a way to somehow skip formula. I have sheet one which has option to select different buildings and only building 1 have manpower number. Sheet two is suppose to let others fill-in number of manpower for Building 2 as needed in column B -Sheet 2. BUT populate Building 1 manpower from sheet 1- if building 1 is selected in sheet 1. I tried conditional formatting using if formula but it doesn't bring me result. I don't know any other way. Can someone help to either write a Macro? I don't want to put formula in Sheet 2-column B because anyone beside building 1 have to manually add number of employees. MUCH MUCH Appreciated. See attachment.
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: VBA to skip formula if criteria doesn't match

    I haven't looked at your file but the first thing is or you have a formula in a cell or you don't you can't have both
    I have no idea what you're trying to achieve but if you want the users to enter a value then you should always use another cell
    In the cell with the formula you van add an If condition to check if the user cell is not empty and the input is valid .
    Validating a cell entry can be used using the data validation rules.
    Conditional format doe not process anything, it just modifies how the content shows up according to your given rules.
    You can protect the cells containing formulas to avoid altering by accident
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. Dragging a formula that increases in count, but doesn't skip
    By tmillo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-20-2016, 09:35 AM
  2. Mark a row if it doesn't match the row above it on multiple criteria
    By kaplanj23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2015, 03:32 PM
  3. Replies: 7
    Last Post: 07-07-2014, 09:48 AM
  4. Skip field if it doesn't meet FIND criteria
    By SWMagic in forum Excel General
    Replies: 3
    Last Post: 04-13-2014, 07:47 PM
  5. [SOLVED] Fill Cells based on 3 Criteria (2 that match and 1 that doesn't)
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2013, 09:40 AM
  6. Formula to delete column if it doesn't match criteria
    By stekng1fan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2009, 02:39 PM
  7. Display 'UNKNOWN' in a cell if the criteria doesn't match
    By famico78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2008, 09: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