filtering problem, wrong rows removed

Hi All,

I have a module that imports data from a text file (120000 rows), filters and removes some unneeded (85000)rows and then puts the data in a designated workbook.
Problem: when filtering by some criteria it for some reason removes a row off the final file for each criteria. I have a total of 23 filtering criteria. I have attached a file for exemplification. You can run the module and import the file, it will be without first 23 rows, even if non of the deleted rows contained the filter criteria.
example.txt

Please Login or Register  to view this content.

Please look into the code and help me figure out what is wrong with it.
Any ideas appreciated.

Taking just this bit of code

Please Login or Register  to view this content.

So what you code does is: it removes all the rows that meat the 23 criteria (exept the last row) including the column header. I think deleting the header is not OK. maybe this should be offset(1,0) instead of offset(0,0)

AutoFilter assumes that you have a header row. You need to add one.

I am adding a header row but it's not working so far. Probably I am adding it in the wrong place in the code sequence.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Do not use unnecessary words like VBA in your thread titles.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

First, you have to work within AutoFilter's limitations; see http://support.microsoft.com/kb/295971 and http://excel.tips.net/Pages/T002403_...own_Limit.html. You may need to break the data up into sections much smaller than 64K rows per sheet.

Second, every sheet needs a header row.

I seem to not be affected by the 1000 limitation.

Does anyone know how can I insert in my code the header row for the second worksheet?

Cheers.