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

	Column 1	Column 2	Column 3
Row 1 (Header)	Div #	Type.	Status
Row 2	01	Example 1	Open
Row 3	02	Example 2	Closed
Row 4	03	Example 3	Closed

<tbody>
</tbody>

Worksheet 2: Div 02

Div #	Type.	Status
02	Example 2	Closed

<tbody>
</tbody>

Worksheet 3: Div 03

Div #	Type.	Status
03	Example 3	Closed

<tbody>
</tbody>

 

[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.