Actually i don't want these extra stars ** in formula star * means next date output.
There should not be stars * if cells are empty
If Ahmer taken 2 leaves in a month then it seems like
Ahmer => Absent - 01/01/20 - Wednesday - N I * Late - 01/05/20 - Wednesday
If he has taken 3 then it seems like
Ahmer => Absent - 01/01/20 - Wednesday - N I * Late - 01/05/20 - Wednesday * Late - 01/11/20 - Wednesday
If he has taken 4 adjustments
Ahmer => Absent - 01/01/20 - Wednesday - N I * Late - 01/05/20 - Wednesday * Late - 01/11/20 - Wednesday - * Late - 01/14/20 - Wednesday
it should not seems like this
Ahmer => Absent - 01/01/20 - Wednesday - N I * * * * Late - 01/05/20 - Wednesday - * * * * * * Late - 01/11/20 - Wednesday - * * * Late - 01/14/20 - Wednesday - * * * Leave - 01/17/20 - Wednesday - * * * * * * * * * * * *
Hi i hope you are doing great, I would like to request that i am using this code since you made but know i want to understand this code would you please add comments in VBA code section that which line does what.
HSAR
Question: How many years experience do You have with coding VBA? If You do not have experience of coding VBA, then You should try to study it eg from these pages https://chandoo.org/wp/vba-classes/
or You would run that code line-by-line and see - what is going on ...
That way, You could understand that code.
To generate a summary for multiple people (ref #7) the named ranges 'Name', 'In', Out' and 'Comment' each are changed to be column relative e.g. =Data!C$3:C$33
rather than =Data!$C$3:$C$33 If the staff each had a separate sheet then local names would have had to be replicated for each sheet.