Re: $$Excel-Macros$$ Attendance tracker 2012

2012-06-18 Thread Suyog
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

Re: $$Excel-Macros$$ Attendance tracker 2012

2012-06-18 Thread Lokesh Loki
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

Re: $$Excel-Macros$$ Attendance tracker 2012

2012-06-18 Thread Lokesh Loki
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

RE: $$Excel-Macros$$ Attendance tracker 2012

2012-06-18 Thread santosh subudhi
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

Re: $$Excel-Macros$$ Attendance tracker 2012

2012-06-17 Thread Lokesh Loki
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 &

Re: $$Excel-Macros$$ Attendance tracker 2012

2012-06-17 Thread Lokesh Loki
Hi All, Please resolve this query whether using formula or an macro. I am waiting for your reply do the needful. Regards Lokesh.M On Sat, Jun 16, 2012 at 6:34 PM, Lokesh Loki wrote: > Hi Experts, > > Till now i did not get any updates from the below request. Please do the > needful brothers. >