Please kindly find attached file want to make the code
i have userform to add attendance to attendance sheet starting in row 8 as in sheet attached
list of operator every time will be appear in list box number one then i select the employee absent list box 2 and transfer to absent list
and if i transfer the data incorrect i can transfer it again to listbox 1
then from list box 1 also i select the employee want to transfer to list box 3 and also can return it again
finally want the sheet come as in my attached file
this is my design
if some one have another simple design can do this in simple way with userform can advice me
Bookmarks