How to improve macro performance for copying rows from one sheet to another

I have a macro which searches through all the rows one sheet and copies each row to another sheet dependant upon the value in a particular cell (quite proud of this as it took me a while to get it working).

The macro runs very slowly though flickering between sheets. Is there some way I can improve the performance of the macro or is there a better way of doing what I am trying to do?

Please Login or Register  to view this content.