I am creating a individual event scheduling tool (see Main Sheet pic below). I have 4 independent tables (TC, R1/2, RM, and R9) where they will list the names of individuals that fall under that category.
I've added the "Add an individual" functionality, and need to create a method to move names between the tables. I created a UserForm (see UserForm pic below) of how I thought this could be accomplished, but need help with the implementation. I've read drag and drop is a possibility, but figured command buttons would be easier.
Here is my thought process:
-User clicks the "Move/Delete Raven" button which opens the UserForm
-User selects an individual in a category and can either click move or delete
-Delete would immediately delete the individual from that category but not update the tables until the user selects "OK"
-Move would open up another UserForm with a dropbox (or some sort of selection method) to pick which category to move them to, and update the list boxes
-The user could move or delete as much as they want without the actual tables being modified, it would just reflect the changes in the list boxes
-If the user clicks "Reset" it would just call the UserForm_Initialize() Sub that would re-initialize the list boxes with the current table configurations
-If the user clicks "Cancel" it would just Unload Me
This was the best way I could think of doing this, you all have any suggestions/improvements? I am definitely not a pro at VBA and will need some help with the programming for this to be functional.
Main Sheet
UserForm
Bookmarks