+ Reply to Thread
Results 1 to 2 of 2

Create new record if value >0

  1. #1
    Registered User
    Join Date
    12-21-2006
    Posts
    36

    Create new record if value >0

    I have a workbook that contains the following columns - Ordered_Qty and Not_Ordered_Qty. I need to write some VBA that, if both Ordered_Qty and Not_Ordered_Qty" are >0, create a new record on the same worksheet and move the Not Ordered Qty into the new record in the same field, replacing the previous value in the original record with 0. I'm using Excel 2007.

    I've only been able to find VBA samples for parsing out comma separated values in the same column.

    The idea is that they don't want to see an ETA Date for something that hasn't even been ordered yet.

    Hope my attachment worked - sample of what I need it to look like.

    Thanks for any help or point in the right direction.

    Toni
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Create new record if value >0

    Something like this?
    Please Login or Register  to view this content.

+ Reply to Thread

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