+ Reply to Thread
Results 1 to 8 of 8

How to add if null function to macro?

  1. #1
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    How to add if null function to macro?

    I have the macro below that works perfect. I need to make an adjustment but not sure where or how. Currently the macro separates the data based on a cell value and only transfers certain columns to new sheets. Well I need to check and see if the cell in AN is null, if it is then it should bring over the value found on BG, if it’s not then bring over AN still.

    The attachment has how the data should look, what you see highlighted is from the cell in BG because AN was Null.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: How to add if null function to macro?

    Try, but:
    1. You write about the 'BG' (Bank 327) column, but you give the values from 'BC' (Bank 129)
    2. You have not written anything about the 'H' column, you only give the value (Bank 128)
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: How to add if null function to macro?

    I would do like this

    Please Login or Register  to view this content.
    kind regards
    Leo

  4. #4
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    Re: How to add if null function to macro?

    Guys I appreciate both of your responses, both worked very well.

  5. #5
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    Re: How to add if null function to macro?

    When I click on edit post, then advanced to mark this closed my original comment is not there. Why?

  6. #6
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: How to add if null function to macro?

    you can mark the case as solved, not closed, and to do this you dont have to go to advanced

    Kind regards
    Leo

  7. #7
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    Re: How to add if null function to macro?

    I meant solved, not closed. When I try that, the original comment is blank.

  8. #8
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: How to add if null function to macro?

    you dont have to edit, somwhere @ top you see button mark tread as solved

    Kind regards
    Leo

+ 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. Count rows with multiple null and not null criteria
    By carlostheba in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2014, 05:16 AM
  2. Blank function/Null function for missing dates
    By knowledgeiskey in forum Excel General
    Replies: 2
    Last Post: 05-21-2010, 05:39 PM
  3. INDEX and MATCH function, NULL value?
    By mabbutt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2009, 07:29 AM
  4. Using IF function to display Null field
    By rockycj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2008, 11:59 AM
  5. Replies: 7
    Last Post: 07-27-2006, 07:15 PM
  6. [SOLVED] Make a field null using IF function
    By [email protected] in forum Excel General
    Replies: 7
    Last Post: 06-20-2006, 02:10 AM
  7. [SOLVED] How do I get a Function to return Null?
    By Peter Chatterton in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2006, 05:50 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