+ Reply to Thread
Results 1 to 2 of 2

Using ISblank not working

  1. #1
    Registered User
    Join Date
    06-10-2021
    Location
    United States
    MS-Off Ver
    2013
    Posts
    1

    Using ISblank not working

    Can you make the ISblank formula work when pulling information from another sheet within the same file?
    Last edited by Summer321; 06-10-2021 at 06:35 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    467

    Re: Trying to add two separate cells and copy down formula, only if a date is populated

    If you can provide a sample file, others can chime in and assist. If you are copying down the formula, select one that has the error and validate that the formula is still looking at the correct cells for the addition and checking..

    In the attached it works for me, take a look and see if this is what you need.
    Attached Files Attached Files
    Last edited by cubangt; 06-10-2021 at 05:27 PM.
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

+ 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. [SOLVED] Copy and append an array of cells based on a separate date table
    By concatch in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-09-2018, 06:23 PM
  2. [SOLVED] Excel2010 IF Formula to return value based on a separate date and two separate text values
    By jakecutler in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2015, 03:24 AM
  3. Copy/move rows beween sheets when date field is populated
    By TCLUTE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2013, 03:46 PM
  4. Copy populated cells to another sheet
    By angiepange in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2013, 12:46 PM
  5. Copy populated cells to another sheet
    By angiepange in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2013, 11:56 AM
  6. Copy values from populated cells only, and identify those cell locations.
    By The Machinist in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2012, 07:02 AM
  7. Replies: 4
    Last Post: 01-31-2012, 01:08 PM

Tags for this Thread

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