Excel column sorting macro

[newexler]

Hi I have a spread sheet which may become huge once and i cannot reveal it.
However i would like to sort the spread sheet based on the coloumns, with a conditional "OK" in some occassions
1. selected 2 coloumns, if data is ok/OK the the entire row has to be copied to another sheet
2. on some occasions selected 3 coloumns has "ok/OK" then entire row has to be copied to another sheet
3. Some occassions if the selected 2 or 3 coloumns have "ok/OK" && AND if the a coloumn "x" is marked as "I" then the entire row has to copied to another sheet.
Please can i get help .. Please want a generic Macro so that i decide which coloumns to look for and what condition.

I created a sample spreadsheet, not sure how to attach it here.

Thanks in advance
--newexler

 

[newexler]

An example i would like to attach here is this

<table x:str="" style="border-collapse: collapse; width: 724pt;" border="0" cellpadding="0" cellspacing="0" width="965"><col style="width: 48pt;" span="10" width="64"> <col style="width: 244pt;" width="325"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" x:num="" height="17" width="64">1</td> <td class="xl24" style="width: 48pt;" x:num="" width="64">2</td> <td class="xl24" style="width: 48pt;" x:num="" width="64">3</td> <td class="xl24" style="width: 48pt;" x:num="" width="64">4</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" x:num="" width="64">5</td> <td class="xl24" style="width: 48pt;" x:num="" width="64">6</td> <td class="xl24" style="width: 48pt;" x:num="" width="64">7</td> <td class="xl24" style="width: 48pt;" x:num="" width="64">8</td> <td class="xl24" style="width: 244pt;" width="325">Description</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" height="17" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 244pt;" width="325">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" height="17" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">OK</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">I</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 244pt;" width="325">Italy</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" height="17" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 244pt;" width="325">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" height="17" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 244pt;" width="325">Germany</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" height="17" width="64">OK</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">Ok</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 244pt;" width="325">Uraguay</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" height="17" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 244pt;" width="325">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" height="17" width="64">No</td> <td class="xl24" style="width: 48pt;" width="64">Ok</td> <td class="xl24" style="width: 48pt;" width="64">Ok</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">I</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 244pt;" width="325">Argentina</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" height="17" width="64">Ok</td> <td class="xl24" style="width: 48pt;" width="64">ok</td> <td class="xl24" style="width: 48pt;" width="64">OK</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">I</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 48pt;" width="64">
</td> <td class="xl24" style="width: 244pt;" width="325">Spain</td> </tr> </tbody></table>
In here for each row if for (columns selected, 1, 2, 3 etc) copy the description in the results sheet. I might have to choose the coloumns based on the my search querry. So also the search sting could be ok/OK; if it is y/Y i will change it search string before running macro