Need vba to list out emp names in listbox and do one or multiple select push to leave type

[MicroTees]

hi experts

i have emp data list i want create attedence tracker for team more friendly user,

i created userform Where i want list out names in listbox, want to copy one or more select option in listbox what are name selected assisgn to leave type by click the command button in absent below.
if 2 employe select and click sick leave it should update as sick leave at back up sheet tracker

there is two team australia and usa i want different section of emp list for userform1 for australia userform2 for usa

once click command button leave type it should store to Tracker list in E:E column
For present if click all present all employer present,
if click rest of all present who are not select for absent those emp are present


find the attachment

[torachan]

attached is first bit - populating listboxes - do you intend overwriting columns 'C:E' with subsequent entries or have you in mind a method of extending the table to capture all entries ?

[MicroTees]

This is action for day to day activity update by team lead who are present and absent, Data fill into row from where last row finished.
Name Col updates from list box selection of number
Department col update from Emp_list vlookup
Location col update from Emp_list vlookup
Leave Type col update from type of leave command button along with selective Emp in list box.

if 3 person gone for sick leave, select those 3 person, click sick command button.

find the attachment with explanation

[MicroTees]

Even if you can make more simple , just do your way i am happy get report by any way

[torachan]

try the attached - done for the 'Australia' form - you should now be able to replicate the code for the 'USA' userform if all the command buttons are the same.

[MicroTees]

Thanks alot sir for your time spend on my thread , bringout easy,Its enough to carry forward as legitimate tracker. i have small request who are select for present rest of all present, i want mark them in tracker as present. its show blank

[torachan]

your small mod done, also the 'USA' userform is now coded for use, I have not fully tested, it is getting an extra row with date in (but this overwrites O.K. with the next day series of entries.

[MicroTees]

Thanks alot sir it works!!! solved

[torachan]

thanks for the feedback and added rep point - glad to have helped.