An error with advanced filter

[thunder_anger]

hi all

i just wanted to filter some codes and copy them to another location but excel keep duplicating the first row

before filter
<table dir="RTL" border="0" cellpadding="0" cellspacing="0" width="104"><col style="mso-width-source:userset;mso-width-alt:3803;width:78pt" width="104"> <tbody><tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl63" dir="LTR" style="height:24.75pt;width:78pt" height="33" width="104">ia1002255</td> </tr> <tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl64" dir="LTR" style="height:24.75pt;border-top:none" height="33">ia45454555</td> </tr> <tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl64" dir="LTR" style="height:24.75pt;border-top:none" height="33">ia6656565</td> </tr> <tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl64" dir="LTR" style="height:24.75pt;border-top:none" height="33">ia323233</td> </tr> <tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl64" dir="LTR" style="height:24.75pt;border-top:none" height="33">ia1002255</td> </tr> <tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl64" dir="LTR" style="height:24.75pt;border-top:none" height="33">ia1002255</td> </tr> </tbody></table>

after filter
<table dir="RTL" border="0" cellpadding="0" cellspacing="0" width="160"><col style="mso-width-source:userset;mso-width-alt:5851;width:120pt" width="160"> <tbody><tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl65" dir="LTR" style="height:24.75pt;width:120pt" height="33" width="160">ia1002255</td> </tr> <tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl66" dir="LTR" style="height:24.75pt;border-top:none" height="33">ia45454555</td> </tr> <tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl66" dir="LTR" style="height:24.75pt;border-top:none" height="33">ia6656565</td> </tr> <tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl66" dir="LTR" style="height:24.75pt;border-top:none" height="33">ia323233</td> </tr> <tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl66" dir="LTR" style="height:24.75pt;border-top:none" height="33">ia1002255</td> </tr> </tbody></table>
so what is happening here

 

[baodinh]

Have you considered that Excel might be treating the first row as a heading row?