Code for nested if-then statements in a loop

[livifivil]

I am unfortunately not able to post my grid at the moment so I will do the best I can to explain the logic plan I had laid out.

Column A = Date
Column C = Job number, String, Example '1005548714023018
Column D = Product
Column H = Amount
Column I = Units
x = range
y = range

Search H
If negative value found return row number x
Return String value in C&x
Search C for match to C&x and return row number y
If all following true, cut and paste rows x and y to new sheet
A&y>=A&x-30 ''within 30 days
D&x=D&y
I&x=I&y
If any false, highlight rows x and y
Continue until last row in Column H

[mjr veverka]

... Return String value in C&x
Search C for match to C&x and return row number y ...

Is it not one and the same ?
Try, but without an example, there is no guarantee that it will work at all.

Please Login or Register  to view this content.

[livifivil]

You're correct and I think that's where I am getting held up. I think your code may work. I will not get to test it until tomorrow but thanks so much for the help. The only thing I didn't see, but now realize I didn't mention, is that if there is no match in C to move on to the next negative value in H. But again, I am not sure how to get past the fact that my code just matches itself. I have to think about this more. Thanks again for the help.