move onboarded selectees to completed table

[bridget_g]

I am trying to get the script/macro to move my selectee from onboarding table to completed table.

437&438-Onboarding table column y= "Move to Completed" is a drop down and is blank until "YES" is selected from the drop down. (that is the only option)

Station

Selectee

Effective Date

Position Title

Position Grade

Position #

Internal or External

Pay Setting Grade/Step

Hiring Authority

Announcement #

CERT #

References Checked (Yes/No)

TJO Extended

TJO Accepted

Extended Memos if needed

Returned Signed Memo

Sent to Suitability

Cleared Suitability

OJO Extended

OJO Accepted

ActiVAte Packet Sent

Supervisor

Specialist

Notes

Move to Completed

1

code

10/01/2024

code

1

code

Internal to Station

1

1

1

1

Yes

10/01/2024

10/01/2024

code

code

10/01/2024

10/01/2024

10/01/2024

10/01/2024

10/01/2024

code

Bridget

code

YES

the table that I am trying to get it to move to is the "437&438-Completed table:

Station

Selectee

Effective Date

Position Title

Position Grade

Position #

Internal or External

Pay Setting Grade/Step

Hiring Authority

VIN #

CERT#

References Checked (Yes/No)

TJO Extended

TJO Accepted

Extended Memos if needed

Returned Signed Memo

Sent to Suitability

Cleared Suitability

OJO Extended

OJO Accepted

ActiVAte Packet Sent

Supervisor

Specialist

Notes

Due to this being a Government device I am using I cannot download the xl2bb to upload the whole workbook.

any assistance will be greatly appreciated

 

[dermie_72]

If you don't want to just filter move to complete and move them all over manually, you could set up an event macro that every time a cell changes in Move to completed to YES, it automatically copies the data to completed and deletes the current row.

I found a sample code on another site that may help. Event macro help