wrote:
>
> Hi Lokesh,
>
> The Problem with "Leave with loss of Pay"for Sachin G.A on 1st july (row #
> 19) is solved.
>
> Regards
> Santosh Kumar Subudhi
>
>
> --
> Date: Mon, 18 Jun 2012 13:47:37 +0530
> Subject: Re: $$Exc
rked in blue.
>
> If the amount is zero without any comments it is "L" row 2 for Anusha
>
> Please check and let me know.
>
> Regards
> Santosh Kumar Subudhi
>
> --------------
> Date: Mon, 18 Jun 2012 13:21:09 +0530
>
> Subject
treated as "M"
> 8 If total amount colum is "0" with the comment Resignation, it should be
> treated as "R"
> 9 If total amount colum is "0" with the comment Joining, it should be
> treated as "J"
>
> I have also created the tracker
ment Resignation, it should be
treated as "R"
9 If total amount colum is "0" with the comment Joining, it should be
treated as "J"
I have also created the tracker based on the above conditions which I have
already sent you in my previous mail.
Regards
Santosh
y date and paste the formula on the 1st sheet.
> 2)Secondly you need to enter the Vlookup formula for each date in second
> sheet and just change the "coloum index number"accordingly.
> 3)Name ranges have been used here( to view them CTRL+F3)
>
> --
> Regards
> Santosh
&
ful brothers.
>
> Regards
> Lokesh.M
>
>
> -- Forwarded message --
> From: Lokesh Loki
> Date: Fri, Jun 15, 2012 at 5:51 PM
> Subject: $$Excel-Macros$$ Attendance tracker 2012
> To: excel-macros@googlegroups.com
>
>
> Hi Experts,
>
> I
