AMD00010
New Member
- Joined
- Jul 12, 2018
- Messages
- 6
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
<tbody>
</tbody>
Worksheet 2: Div 02
<tbody>
</tbody>
Worksheet 3: Div 03
<tbody>
</tbody>
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>