Results 1 to 8 of 8

Excel 2007 : formula to copy only rows of data based on leading cells value

Threaded View

  1. #1
    Registered User
    Join Date
    05-14-2009
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    7

    formula to copy only rows of data based on leading cells value

    In an attempt to make this more automated for the user, I have run into a road block.

    The goal is to populate the cells in columns AA, AB, AC with data from D, E and F. However, I only want this function IF B has a value greater than 0.

    If that value in B is =0, then I do not want anything copied.

    I have tried to write this with the "IF" function, but can't fill in AA, AB, AC with out blank rows in the place of the skipped over (or unwanted) data.

    The Values for D, E, and F are linked from another workbook and currently the user has to copy and paste the values themselves. This is error prone when doing 20 or 30 entries in a day.

    I have attached a worksheet that contains what I WANT the RESULT to LOOK like.
    Attached Files Attached Files
    Last edited by Paul; 06-05-2009 at 12:06 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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