Need make code faster.

Hi I have below code which have to be used in a very big sheet many rows. around 500000 or more. Its very slowly of course and also i need a code more to be sure its filtered correct, before i run the last code.- But if the codes can be so they run faster would be great. The filtering have to come in this order.

First i run below code. And that can maybe be done faster. It delete rows in different conditions and in this order,

Please Login or Register  to view this content.

Here between i need a new code. It has to delete all the row, if the cell A and b and c are empty. I have found some but they did not work. So between the first and the last i need this new code. All suggestions are welcome also to put the codes together .

Finally the last code will run. Brilliant code by jindon. It merge the text in column B until next date in column a., It works perfect dont know if this can be made faster.

Here is the last code.

Please Login or Register  to view this content.

Please have a look i cant upload the sheet its very big and thats the problem So hope you can help with out this.

Thanks in advance.

Sincerely
Abjac

HI Thanks for the answer. Its not the 8 seconds which make the code slowly. It take nearly one hour to run in a sheet with over 500000 rows. I put the seconds before because it was 4 codes call each other. and i preferred to see when one was finish.- But that is not what make it slowly. Its the big amount of rows. Also as i said i need one more code. Between the 2 codes. If cell a and b and c are blank it has to delete the complete row. According to that the macroes take hours to run i could really need some change if possible.
Have a look thanks

Sincerely
Abjac

Not sure, but try AdvancedFilter instead of AutoFilter. (Normally faster)
If you need a hand, need to see your sheet layouts with just 10-20 rows of data.

Hi thanks allot. I am a little handicapped seems my company have closed access to excel forum security risk Hehe. But when home I will try also upload a test sheet. Send from my mobile. Sincerely abjac

HI Just tried it at home but its not excel 2013. Tomorrow will try at the big file at my work. I think its brilliant but i will check tomorrow. Thanks for now kalbasiatka. Sincerely Abjac

HI Kalbasiatka.

I tried the macro on the big file and i cant find out where the error is. It has around 500000 rows so i cant upload it here. It give me a error in this line.

If a(ii, 3) <> "" Then And it say "type mismatch"

If any idea what that can be will be great to know.

Please have a look and sorry i cant upload the real big file. If any email i could do to you private maybe.

Please have a look

Sincerely

abjac

HI I think i found the error. Some cells in row C had a = in front so it was standing like a formula . I run a find and replace to get them of. After it was working.
The only problem i have now, is that there is still blanks rows. I need a fast macro to remover them. Because if not the last code dont work.

Please have a look if time to get a very fast code to remove blanks. Its over 500000 rows,

After remove blanks i need run this code from Jindon. It merge the text in row c in one row until the next date in row B. But this one stop if it come to a blank row,

Please have a look.

Sincerely
Abjac


the code i have to run in the end. Is the last code called test in top of the thread.

HI I got a solution which was needed. I split the big excel up in 2 sheets, with around 288000 in each and now the last code run through in both of them. I wish the last code could be faster and also not need not to have any blanks. But its working.
Thanks allot kalbasiatka your code was brilliant and it solved allot for me. The last code is from jindon and its brilliant too but have problem in very big sheets. But great help thanks