Automatically move rows from one worksheet to another when condition is met - Please help

Hi dxbFoss and welcome to the forum,

Here is the code that should do what you ask: It is also included in the attached workbook.

Please Login or Register  to view this content.

Hi,

The problem is that you have your Sales Forcast sheet as a TABLE. Select anywhere in the table and click on the Data Tab and then the Filter Icon. This will them let my macro work correctly. See the attached that uses the same code. You simply need to remove the table status of the Sales Forcast sheet.

You could create a button that would click and run the macro, but for now I'd click on the developer tab and Run the Macro. What do you want to do?

here is an another alternative.
Instead of looping through, I have used inbuild Advanced Filter Method of Range Object.

You can also change your criteria in the ColH.

Read more about advanced filter here. As they can provide plenty of conclusions at blink of an eye.
http://www.tushar-mehta.com/publish_...lysis/06.shtml

I have removed the table status from both the sheets for favoring my method.
Here is the code:-

Please Login or Register  to view this content.

Check the attached file:-