Hi,
Attached is a workbook that has a multi-tab Userform. The first 2 tabs work the way I need. I am having trouble with the 3rd tab (Employee Termination).
What I want it to do:
1.The Full Name combo box, I want to pull all the names from column C on the "Test" sheet.
2. Once a name and date are picked, and the "Enter" button is clicked,
a. The macro would find the name picked within the "Test" spreadsheet
b. Copy the row from the table
c. Paste the row in the table, 1 column over, in the "Termination" spreadsheet
d. Add the date that was selected in the Userform into column A in the "Termination" spreadsheet
e. Delete the empty row in the "Test" sheet
Thank you!
Bookmarks