VBA Move Row to Another Sheet Based on 2 Criteria

[AMD00010]

Hello --

Looking for help with the following situation.

I'd like to move an entire row from "Worksheet 1: Pending Items" to another Worksheet based on the value in Column 1 and the Status in Column 3. In my simplified example below (header row in bold), I'd like Row 3 from "Worksheet 1: Pending Items" to move to "Worksheet 2: Div 02" when the Status is marked close and because the Value in Column 1 is 02. This would repeat for all values in Column 1; i.e. Row 4 would move to "Worksheet 3: Div 03" when the Status in Column 3 is marked Closed. And so on.

Anyone have a solution I can try? Thanks in advance.

Worksheet 1: Pending Items
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Column 1[/TD]
[TD]Column 2[/TD]
[TD]Column 3[/TD]
[/TR]
[TR]
[TD]Row 1 (Header)[/TD]
[TD]Div #[/TD]
[TD]Type.[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Row 2[/TD]
[TD]01[/TD]
[TD]Example 1[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]Row 3[/TD]
[TD]02[/TD]
[TD]Example 2[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]Row 4[/TD]
[TD]03[/TD]
[TD]Example 3[/TD]
[TD]Closed[/TD]
[/TR]
</tbody>[/TABLE]

Worksheet 2: Div 02
[TABLE="width: 500"]
<tbody>[TR]
[TD]Div #[/TD]
[TD]Type.[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]02[/TD]
[TD]Example 2[/TD]
[TD]Closed[/TD]
[/TR]
</tbody>[/TABLE]

Worksheet 3: Div 03
[TABLE="width: 500"]
<tbody>[TR]
[TD]Div #[/TD]
[TD]Type.[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]03[/TD]
[TD]Example 3[/TD]
[TD]Closed[/TD]
[/TR]
</tbody>[/TABLE]

 

[AMD00010]

Confirming it works in the larger spreadsheet, just added it in. THANK YOU AGAIN.

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Confirming it works in the larger spreadsheet, just added it in. THANK YOU AGAIN.