Hello All. I need help with this little project.
As you can see on sheet5, Request Raw, a list of employee data and their requested date. If you open the userform via the "Check Leaves" button, it will display a listbox with the same data on sheet5. Below the listbox are 2 cmdbtns - Approve, Reject. What we want to happen is, a user will select an entry on the listbox. After selecting, they will click either Approve or Reject. If Approve/Rejected, I want the entry to be transferred from Request Raw to "Status" sheet. This sheet is almost the same as the other one with the addition of Status and Approved Date column. Status column will show the status if Approve or Rejected. Approved date will show the date approved which is the date showed in the listbox besides the cmdbuttons. I say "transferred" above because once status is selected, I want it removed from the listbox. Thus, removing it also on the Request Raw sheet.
Thank you in advance for the help!