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
It is the line that starts with
... please help... :)
Source code:
Bookmarks