Re: $$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2015-11-22 Thread Akash Singh
hi, shared only example format data like that On Saturday, November 21, 2015 at 9:30:37 PM UTC+5:30, pramodb35 wrote: > > Akash. > Kinldy Share Excel File > > On Sat, Nov 21, 2015 at 9:01 PM, Akash Singh > wrote: > >> Hi, > > > > Can anyone guide who write a code in VBA in excel to find the

Re: $$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2015-11-21 Thread Pramod Singh
Akash. Kinldy Share Excel File On Sat, Nov 21, 2015 at 9:01 PM, Akash Singh wrote: >> Hi, > > Can anyone guide who write a code in VBA in excel to find the employee > attendance record or check whether employee working more than 6 day in a > week > > akash > > -- > Are you =EXP(E:RT) or =NOT(EXP(

Re: $$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2013-01-04 Thread prkhan56
WOW! Suupe! Works like a magician wand. Thanks thanks thanks a lot. Regards Rashid Khan On Friday, January 4, 2013 8:38:18 AM UTC+4, Lalit Mohan Pandey wrote: > Hi Rashid, > > Paste below code in the same module where the previous procedure is saved > and assign this pro

Re: $$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2013-01-03 Thread Lalit Mohan Pandey
Hi Rashid, Paste below code in the same module where the previous procedure is saved and assign this procedure to the shape. *Sub StartProcess()* * * *Dim varData() As Variant* *Dim rngRangeAs Range* * * *Const strRawDataShtName

Re: $$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2013-01-03 Thread prkhan56
**Thanks Lalit I can see the sample sheet and the code works fine. As I requested in my previous post, can you please amend your code to look for *Col A - Date/Time* (the present code looks for Date/Time in Col B) *Col B - Name* (the present code looks for Name in Col A) If you can please amend

Re: $$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2013-01-03 Thread mohan . pandey87
Hi Rashid, There is a sheet to make it visible just press alt + f11 in left side there is a sheet named sample goto its properties visible and select visible Regards, Lalit Mohan Sent from BlackBerry® on Airtel -Original Message- From: prkhan56 Sender: excel-macros@googlegroups.com Dat