Advance filtering

Hi there,
wonder if any one can help me.

I have a huge file containing over 80000 lines of info. like client account,date,document type, document no., amount debit, amount credit, description, etc,
no if I would like to filter according to account number and copy them to another worksheet. I used advance filter on account number. it copies not the exact account number but the requested account and similar ones, e.g. if account number C001 is request it filters besides C001 also C0011 and C0012 etc.

how can I filter only the requested account number

thanks
Khalid

Thank you very much Leo Taxi

With the code that you have sent me, it still not working, could be because my LIST RANGE is very big more than 80000 lines. I would like, if you may send my form in an attachment, but I dont seen to know how can I attach a file as you did.

thanks

Thank you very much Leo Taxi

With the code that you have sent me, it still not working, could be because my LIST RANGE is very big more than 80000 lines. I would like, if you may send my form in an attachment, but I dont seen to know how can I attach a file as you did.

thanks

Dear sir,

can you please examine the attached file, and tell me please where is the error.

thank you
khalid

Sorry I was not able to upload the attachment as it is very big

Please provide a cut-down version of your workbook with just enough data for members here to be able to work with to help solve your problem. Help us to help you!