Macro stops working on row

I ran your macro and it is not stopping at row 221. There are only 221 entries that are being extracted. The two filter lines

Please Login or Register  to view this content.

are restricting the number of entries that you are extracting. Are you sure that these two tests are correct for what you want to do?

Originally Posted by blane245

The two filter lines ...are restricting the number of entries that you are extracting. Are you sure that these two tests are correct for what you want to do?

Unfortunately I barely can read VBA code, so I'm not really sure, I got this code from someone else on this board and I do not fully understand it. Perhaps could you explain what it means, or better yet, help me fix it to do what I want it to do?

Going back to my original post, the problem I am trying to solve is that in the raw data, there are often several lines for a unique order number/line number combination. for each Order number/line number combination, I only want to pull out the first time that "Next Stat" = 530 and the first time "Next Stat"=540. Everything else can be deleted.

Originally Posted by Leith Ross

Hello smokebreak,

The code is designed to only copy unique values from sheet to the other. Currently, there are only 221 unique entries on "Sheet1".

Should I re-open my original question then, or should I pursue the issue in this thread? My original post is here:
http://www.excelforum.com/excel-prog...-column-c.html

The macro has ceased going through all the data in the set. my original data was a lot like the sample on my first post. I added the columns and then found that the macro no longer did what I needed it to do. Still not sure what I did wrong, since all I did was change the column numbers in the script. All I need it to do is sort through each order/line combination for the first instances of "Next Stat"=530 and =540.

oh my, please accept my apology:
I posted a "stripped down" solution to the problem which may or may not help you, but almost certainly doesn't warrant two threads:

http://www.excelforum.com/excel-prog...ml#post2238910

The idea is basically to have the macro add a column to concatenate order number, line number, and next stat. (may also have to reformat the line number to include a leading zero). Then loop through the concatenated data and find the first instances of the last 3 digits being appropriate to what I'm looking for... once the rows are deleted, the concatenated column could be removed also. I think it will work that way but don't want to derail your solution if you are working on something more elegant.

As a mod please delete that other thread if it is inappropriate. I didn't see your reply until just now.

*shame*

FINALLY a solution that works. Thank you for your persistence to help a stranger, Leith.