+ Reply to Thread
Results 1 to 2 of 2

Check Range for negative value, and add to value if it already exists

  1. #1
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Check Range for negative value, and add to value if it already exists

    Hey everyone, I have a bit of a problem I cannot seem to solve.

    So I have a bunch of worksheets that have part numbers for rows and weeks 1 - 13 for columns. When the user makes a selection, I want it to scan the selected week, in each sheet, for negative numbers.

    This works fine for the first sheet, but when it switches the second sheet and runs, I want it to check if that part number is already on the list and ADD it to the old number instead of making a new line.

    So far, everything works EXCEPT it adds the value to the old number but IT ALSO creates a new line. These are seperate IF and ELSE parts. I don't get why it is doing both. Here is a picture of the output I DONT want. It should only be the first two lines of the list box.

    Capture.jpg

    The source code is below. The problem part is almost near the bottom and starts after the comment
    Please Login or Register  to view this content.
    It is the line that starts with
    Please Login or Register  to view this content.

    ... please help... :)

    Source code:
    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by ericbartha; 07-06-2015 at 02:33 PM. Reason: Changed IMG to supported File Type

  2. #2
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: Check Range for negative value, and add to value if it already exists

    Bump for updated title

+ 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] Nested Sumif's or how to sum data based on nested criteria
    By dlietz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-07-2014, 11:36 AM
  2. How to reduces Nested IF code(144 Nested IF) to achive same functionality
    By jobseeker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2014, 09:45 AM
  3. Replies: 0
    Last Post: 10-01-2012, 05:54 AM
  4. For each loop nested; getting stuck on one cell in first iteration of nested loop
    By Excel_vba in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-22-2009, 11:54 AM
  5. help on a nested countif/nested if formula
    By vickiemc in forum Excel General
    Replies: 2
    Last Post: 08-13-2008, 08:29 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