Hi Jocky, I'm checking out the reason of error. Anyway see your text file
attached to test another worksheet.
Basole.
Em quarta-feira, 16 de outubro de 2013 11h40min34s UTC-3, jocky Beta
escreveu:
>
> Hi Team,
>
> I need help on above attached sheets, In the excel sheet i should browse
> the PDF file (which is attached in this mail ) and then the output data
> should be come in given format.
>
> Looking forward your co-operation
>
> 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/groups/opt_out.
Entry / Exit Status Report
Date : 10/14/2013 00:00:00 To 10/14/2013 23:59:59
Print Date : 10/15/2013
Date / Time Card Holder Door
Zone Status
10/14/2013 00:00:18 0228 - 0228 Security Magarpatta 05-7 JBT Fire
Exit(I/O) Exit
10/14/2013 00:01:39 0078 - 0078 SG 7Floor 01 07-7 Fire Exit
6 Floor Exit
10/14/2013 00:01:49 0228 - 0228 Security Magarpatta 05-3 JBT Fire
Exit(I/O) Entry
10/14/2013 00:02:29 0290 - 0290 Test card 08-1 1st FL
Tripod Entry(I) Entry
10/14/2013 00:03:04 0228 - 0228 Security Magarpatta 02-6 JBT Main
Door Exit(O) Exit
10/14/2013 00:04:19 0290 - 0290 Test card 08-6 1st FL
Tripod Exit(O) Exit
10/14/2013 00:06:35 0228 - 0228 Security Magarpatta 01-1
702-Reception Entry(I) Entry
10/14/2013 00:06:40 0078 - 0078 SG 7Floor 01 07-3 Fire Exit
6 Floor Entry
10/14/2013 00:07:01 0228 - 0228 Security Magarpatta 04-1 702 Lab
door(I/O) Entry
10/14/2013 00:09:27 0228 - 0228 Security Magarpatta 04-1 702 Lab
door(I/O) Entry
10/14/2013 00:10:33 0078 - 0078 SG 7Floor 01 07-5 6 Floor
main Exit-2(I) Exit
10/14/2013 00:11:42 0078 - 0078 SG 7Floor 01 06-2 6 Floor
Main Ent-2(O) Entry
10/14/2013 00:15:38 0078 - 0078 SG 7Floor 01 07-4 Server
Room 6 Floor Entry
10/14/2013 00:15:56 0078 - 0078 SG 7Floor 01 07-5 6 Floor
main Exit-2(I) Exit
10/14/2013 00:18:00 0228 - 0228 Security Magarpatta 03-7 702 Fire
Exit(I/O) Exit
10/14/2013 00:22:27 0228 - 0228 Security Magarpatta 03-3 702 Fire
Exit(I/O) Entry
10/14/2013 00:25:21 0228 - 0228 Security Magarpatta 01-6
702-Reception Exit(O) Exit
10/14/2013 00:51:23 0078 - 0078 SG 7Floor 01 06-2 6 Floor
Main Ent-2(O) Entry
10/14/2013 00:51:31 0228 - 0228 Security Magarpatta 06-2 6 Floor
Main Ent-2(O) Entry
10/14/2013 00:53:07 0078 - 0078 SG 7Floor 01 07-4 Server
Room 6 Floor Entry
10/14/2013 00:58:04 0228 - 0228 Security Magarpatta 07-7 Fire Exit
6 Floor Exit
10/14/2013 00:58:13 0078 - 0078 SG 7Floor 01 07-5 6 Floor
main Exit-2(I) Exit
10/14/2013 01:01:18 0228 - 0228 Security Magarpatta 03-3 702 Fire
Exit(I/O) Entry
10/14/2013 01:01:54 0228 - 0228 Security Magarpatta 04-1 702 Lab
door(I/O) Entry
10/14/2013 01:02:26 0228 - 0228 Security Magarpatta 04-1 702 Lab
door(I/O) Entry
10/14/2013 01:02:50 0228 - 0228 Security Magarpatta 01-6
702-Reception Exit(O) Exit
10/14/2013 01:09:21 0228 - 0228 Security Magarpatta 02-1 JBT MAIN
door Entry(I) Entry
10/14/2013 01:09:30 0290 - 0290 Test card 08-1 1st FL
Tripod Entry(I) Entry
10/14/2013 01:09:53 0228 - 0228 Security Magarpatta 05-4 JBT
Server(I/O) Entry
10/14/2013 01:10:18 0228 - 0228 Security Magarpatta 05-4 JBT
Server(I/O) Entry
10/14/2013 01:10:42 0290 - 0290 Test card 08-6 1st FL
Tripod Exit(O) Exit
10/14/2013 01:10:43 0228 - 0228 Security Magarpatta 05-7 JBT Fire
Exit(I/O) Exit
10/14/2013 01:11:59 0228 - 0228 Security Magarpatta 05-3 JBT Fire
Exit(I/O) Entry
10/14/2013 01:12:37 0228 - 0228 Security Magarpatta 02-6 JBT Main
Door Exit(O) Exit
10/14/2013 01:37:14 0228 - 0228 Security Magarpatta 01-1
702-Reception Entry(I) Entry
10/14/2013 02:07:36 0290 - 0290 Test card 08-1 1st FL
Tripod Entry(I) Entry
10/14/2013 02:10:07 0290 - 0290 Test card 08-6 1st FL
Tripod Exit(O) Exit
10/14/2013 03:05:39 0290 - 0290 Test card 08-1 1st FL
Tripod Entry(I) Entry
10/14/2013 03:08:25 0290 - 0290 Test card 08-6 1st FL
Tripod Exit(O) Exit
10/14/2013 03:32:43 0228 - 0228 Security Magarpatta 03-7 702 Fire
Exit(I/O) Exit
10/14/2013 03:39:30 0228 - 0228 Security Magarpatta 03-3 702 Fire
Exit(I/O) Entry
10/14/2013 03:40:54 0228 - 0228 Security Magarpatta 04-1 702 Lab
door(I/O) Entry
10/14/2013 03:43:32 0228 - 0228 Security Magarpatta 04-1 702 Lab
door(I/O) Entry
10/14/2013 03:43:55 0228 - 0228 Security Magarpatta 01-6
702-Reception Exit(O) Exit
10/14/2013 03:44:19 0228 - 0228 Security Magarpatta 02-1 JBT MAIN
door Entry(I) Entry
10/14/2013 03:44:50 0228 - 0228 Security Magarpatta 05-4 JBT
Server(I/O) Entry
10/14/2013 03:45:31 0228 - 0228 Security Magarpatta 05-4 JBT
Server(I/O) Entry
10/14/2013 03:45:59 0228 - 0228 Security Magarpatta 05-7 JBT Fire
Exit(I/O) Exit
10/14/2013 03:47:07 0228 - 0228 Security Magarpatta 05-3 JBT Fire
Exit(I/O) Entry
10/14/2013 04:34:09 0078 - 0078 SG 7Floor 01 06-2 6 Floor
Main Ent-2(O) Entry
10/14/2013 04:36:02 0078 - 0078 SG 7Floor 01 07-4 Server
Room 6 Floor Entry
10/14/2013 04:43:30 0078 - 0078 SG 7Floor 01 07-7 Fire Exit
6 Floor Exit
10/14/2013 04:48:29 0078 - 0078 SG 7Floor 01 07-3 Fire Exit
6 Floor Entry
10/14/2013 04:53:49 0078 - 0078 SG 7Floor 01 07-4 Server
Room 6 Floor Entry
10/14/2013 04:54:37 0078 - 0078 SG 7Floor 01 07-5 6 Floor
main Exit-2(I) Exit
10/14/2013 04:58:09 0228 - 0228 Security Magarpatta 05-4 JBT
Server(I/O) Entry
10/14/2013 04:58:52 0228 - 0228 Security Magarpatta 05-7 JBT Fire
Exit(I/O) Exit
Page : 1
