Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

2014-04-16 Thread Eugene Bernard
good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Eugene Bernard > *To:* excel-macros

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

2014-04-15 Thread Paul Schreiner
es you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Eugene Bernard >To: excel-macros@googlegroups.com >Sent: Monday, April 14, 2014 12:39 PM >Subject: Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

2014-04-14 Thread Eugene Bernard
places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > *From:* Ganesh N > *To:* "excel-macros@googlegroups.com" > *Sent:* Tuesday, April 8, 2014 9:14 AM > *Subject:* Re: $$Excel-Macros$$ Need help to fin

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

2014-04-08 Thread Ganesh N
Thanks Paul & Ashish Regards, Ganesh N On Wed, Apr 9, 2014 at 12:14 AM, ashish koul wrote: > Sub sample() > Dim i As Long > Dim rng As Range > Dim strng As Long > Dim endrng As Long > Sheets("Sheet1").Range("a1:b" & > Sheets("Sheet1").Range("a1").End(xlDown).Row).Sort > key1:=Sheets("Sheet

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

2014-04-08 Thread ashish koul
Sub sample() Dim i As Long Dim rng As Range Dim strng As Long Dim endrng As Long Sheets("Sheet1").Range("a1:b" & Sheets("Sheet1").Range("a1").End(xlDown).Row).Sort key1:=Sheets("Sheet1").Range("b:b"), order1:=xlDescending, Header:=xlYes On Error Resume Next i = Application.WorksheetFunction.Match(

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

2014-04-08 Thread Paul Schreiner
s ever you can.” - John Wesley - > > From: Ganesh N >To: "excel-macros@googlegroups.com" >Sent: Tuesday, April 8, 2014 9:14 AM >Subject: Re: $$Excel-Macros$$ Need help to find the missing emp id on >

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

2014-04-08 Thread Ganesh N
Hi Team, Any updates on the request ?? Thanks & Regards, Ganesh On Tue, Apr 8, 2014 at 1:15 PM, Ganesh N wrote: > Hi Team, > > Need a help in find the missed emp id list. > > Sheet1 have the actual employee ids and date. In sheet2 have overall > employee ids in that i need to find the employe