+ Reply to Thread
Results 1 to 2 of 2

copy if formula retrieving blank rows

  1. #1
    Registered User
    Join Date
    12-11-2013
    Location
    toronto
    MS-Off Ver
    Excel 2007
    Posts
    1

    copy if formula retrieving blank rows

    We have an excel spreadsheet with multiple tabs and VB programming. It was doing everything we ever wanted, until we have added a new tab "Current year". We are trying to take information from the "Master" tab and copy it to the "Current year" tab if column G has a date that is the current year "2013". (cell G is yyyy format).
    Both spreadsheets(“Data file” and “Current year”) have column headings and the data input starts at A5 and goes to L250.
    We added the formula =IF('Input here'!$G2=2013,'Input here'!A2,"") to cell A2 on the "2013" tab and copied it across and down. It seems to copy the data we require, but is giving blank lines when the criteria is not. We do not want the end user to have to filter the blank lines out. Does anyone know a code/or formula that will copy the data and not retrieve blank lines?
    We tried to use the same formula we used for the other tabs, but could not get it to work. We figured the easiest way was adding the formula above to the spreadsheet.
    Any help is greatly appreciated.
    Attached Files Attached Files
    Last edited by answerunknown; 12-11-2013 at 04:06 PM.

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: copy if formula retrieving blank rows

    Hi answerunknown,

    I don't know of a way to do what you're asking, but you could try using this table as the data source for a Pivot table & uncheck the 'Blank' checkbox on the Pivot table filter.

    Hope this helps (Hth)
    Remember you are unique, like everyone else

+ 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. How to create a macro to insert blank rows and copy data into blank rows?
    By zodiack101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2013, 01:18 PM
  2. [SOLVED] Formula: copy rows in a range, based on non-blank values in one of the columns
    By Glenn Kennedy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-16-2013, 09:08 AM
  3. Copy Formula from set cells, paste in blank rows below as value
    By cappie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2013, 02:45 PM
  4. Copy formula down to last row of previous column which has blank rows on top
    By sam747 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-11-2012, 08:24 PM
  5. Copy Paste Formula on Each Blank Rows
    By triaji in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-26-2010, 10:53 AM

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