I suspect that what you've provided is a data sample that may not be realistic. Will the values in the "Reader" column actually SAY "In" and "Out"? or are these clock rings from users? and, the date/time for each "IN" ring is probably not the exact time for the corresponding "OUT" ring.
I can write a macro that reads from the earliest time to the latest, and look for matching "Reader" and show the time difference between in/out. Then, if there is no "out", then indicate the missing record. But it would help if I had a realistic data set to work with. Paul ----------------------------------------- “Do all the 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: Jocky Beta <jocky6...@gmail.com> >To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> >Sent: Friday, July 25, 2014 6:40 AM >Subject: Re: $$Excel-Macros$$ Need help in creating macro > > > >Hi All, > > >Any hope regarding on this? > > > > > >On Friday, July 25, 2014, Jocky Beta <jocky6...@gmail.com> wrote: > >Hi vaibhav it will be ok for me if it will be highlited by colour , >> >> >>Regards >> >>On Friday, July 25, 2014, Vaibhav Joshi <v...@vabs.in> wrote: >> >>Don't you think there will be too much of pop ups, instead how about >>highlighting it with color? >>> >>> >>> Cheers!! >>> >>> >>> >>>On Fri, Jul 25, 2014 at 11:56 AM, Jocky Beta <jocky6...@gmail.com> wrote: >>> >>> >>>>Hi team, >>>> >>>> >>>>I need some help in creating macro for an excel sheet. I have worksheet in >>>>which 18 nos of in and out transaction are reflected. I need macro for any >>>>one of transaction out of these 18 is missed it shuld show a popup message >>>>stating that transaction >>>> >>>> >>>>Your help on the same will be appreciated >>>> >>>> >>>>Regards >>>> >>>> >>>> >>>> -- >>>>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >>>>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>https://www.facebook.com/discussexcel >>>> >>>>FORUM RULES >>>> >>>>1) Use concise, accurate thread titles. Poor thread titles, like Please >>>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>>will not get quick attention or may not be answered. >>>>2) Don't post a question in the thread of another member. >>>>3) Don't post questions regarding breaking or bypassing any security >>>>measure. >>>>4) Acknowledge the responses you receive, good or bad. >>>>5) Jobs posting is not allowed. >>>>6) Sharing copyrighted material and their links is not allowed. >>>> >>>>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>>>members are not responsible for any loss. >>>>--- >>>>You received this message because you are subscribed to the Google Groups >>>>"MS EXCEL AND VBA MACROS" group. >>>>To unsubscribe from this group and stop receiving emails from it, send an >>>>email to excel-macros+unsubscr...@googlegroups.com. >>>>To post to this group, send email to excel-macros@googlegroups.com. >>>>Visit this group at http://groups.google.com/group/excel-macros. >>>>For more options, visit https://groups.google.com/d/optout. >>>> >>> -- >>>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >>>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>https://www.facebook.com/discussexcel >>> >>>FORUM RULES >>> >>>1) Use concise, accurate thread titles. Poor thread titles, like Please >>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >>>not get quick attention or may not be answered. >>>2) Don't post a question in the thread of another member. >>>3) Don't post questions regarding breaking or bypassing any security measure. >>>4) Acknowledge the responses you receive, good or bad. >>>5) Jobs posting is not allowed. >>>6) Sharing copyrighted material and their links is not allowed. >>> >>>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>>members are not responsible for any loss. >>>--- >>>You received this message because you are subscribed to the Google Groups >>>"MS EXCEL AND VBA MACROS" group. >>>To unsubscribe from this group and stop receiving emails from it, send an >>>email to excel-macros+unsubscr...@googlegroups.com. >>>To post to this group, send email to excel-macros@googlegroups.com. >>>Visit this group at http://groups.google.com/group/excel-macros. >>>For more options, visit https://groups.google.com/d/optout. >>> >-- >Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. >2) Don't post a question in the thread of another member. >3) Don't post questions regarding breaking or bypassing any security measure. >4) Acknowledge the responses you receive, good or bad. >5) Jobs posting is not allowed. >6) Sharing copyrighted material and their links is not allowed. > >NOTE : Don't ever post confidential data in a workbook. Forum owners and >members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To unsubscribe from this group and stop receiving emails from it, send an >email to excel-macros+unsubscr...@googlegroups.com. >To post to this group, send email to excel-macros@googlegroups.com. >Visit this group at http://groups.google.com/group/excel-macros. >For more options, visit https://groups.google.com/d/optout. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
