Condition based on another Condition

**ghadghoud** · 10-17-2011, 10:54 PM

Hi all,

I need to know how is it possible to base a condition on another one. For example, in the column dj above If the number are greater or equal to 8, just for these lines I wanna choose the line that has the greater number in the column pj.
so the answer for this exemple should be N0 1
How can I do this with VBA?

Thank you for your help

**ghadghoud** · 10-18-2011, 12:04 AM

I attached an excel Workbook to be make my issue clearer.

First, what I want to do is to find the rows in which the column D has numbers greater or equal to 8. If there is more than one rows found, I want to find which one has the largest number in the column C. When i find this row (in this case: row number 4) I want to move this line to the end of the table.
Then I want to repeat the same steps for the 3 remaining rows.

Your help is highly appreciated (before this Thursday )