MrCameronExcel
New Member
- Joined
- Apr 21, 2017
- Messages
- 43
- Office Version
- 365
- Platform
- Windows
Hello,
I am looking for some help creating VBA code that will transfer expired rows from the first worksheet - called "Valid Clearances" - to the second worksheet - called "Expired Clearances"
I initially troubleshooted this issue via google, but the codes I found never worked when I tried to apply them.
Below is a sample table of what both worksheets look like.
The first two rows of both worksheets will remain the same, but I would like to apply a code so that every time I open the workbook, it automatically moves expired rows - based on the expiry date column (J) - to the bottom of the table on the second worksheet (Expired Clearances).
Any help is appreciated!
<tbody>
</tbody>
I am looking for some help creating VBA code that will transfer expired rows from the first worksheet - called "Valid Clearances" - to the second worksheet - called "Expired Clearances"
I initially troubleshooted this issue via google, but the codes I found never worked when I tried to apply them.
Below is a sample table of what both worksheets look like.
The first two rows of both worksheets will remain the same, but I would like to apply a code so that every time I open the workbook, it automatically moves expired rows - based on the expiry date column (J) - to the bottom of the table on the second worksheet (Expired Clearances).
Any help is appreciated!
| Original Record | Internal Record | |||||||||||||||
| ARSC | Batch # | Ref. # | Legal Company Name | Last Name | First Name | Person Type | Assigned To | Status | Expiry Date | Submit date | primary | current company name | current status | telephone | notes | |
| 442 | B-8388 | C-4848 | Company A | Chad | Chad | Worker | Cam | Granted | 9/23/2017 | 9/21/2017 | cam | Company A | Worker | 444-444-4444 | sample@sample.com | sample notes |
<tbody>
</tbody>
