S
sventer
Hi
If any one can help would appreciate it.
i have a macro that copies and pastes i.e ENTRY BASE[In] in the next
column of 13:17:58 then deletes the emty row but when it gets to
13:21:00 it will copy 13:22:34 instead i need some vb to skip this row
every time it gets to an 'Admitted' and not in or out.
03/12/2007 13:17:58 Admitted SETATI, PHATUDI [49] (Card #12923) at F
PARKADE BOOM 3
ENTRY BASE [In]
03/12/2007 13:19:18 Admitted KEARNS, MARGATEHA [13] (Card #13848) at
F PARKADE
EXIT [Out]
03/12/2007 13:21:00 Admitted LOO, JASON [48] (Card #5751) at F
PARKADE BOOM 2
03/12/2007 13:22:34 Admitted BRAY, ROBERT [20] (Card #1345) at F
PARKADE BOOM 2
[Out]
regards
If any one can help would appreciate it.
i have a macro that copies and pastes i.e ENTRY BASE[In] in the next
column of 13:17:58 then deletes the emty row but when it gets to
13:21:00 it will copy 13:22:34 instead i need some vb to skip this row
every time it gets to an 'Admitted' and not in or out.
03/12/2007 13:17:58 Admitted SETATI, PHATUDI [49] (Card #12923) at F
PARKADE BOOM 3
ENTRY BASE [In]
03/12/2007 13:19:18 Admitted KEARNS, MARGATEHA [13] (Card #13848) at
F PARKADE
EXIT [Out]
03/12/2007 13:21:00 Admitted LOO, JASON [48] (Card #5751) at F
PARKADE BOOM 2
03/12/2007 13:22:34 Admitted BRAY, ROBERT [20] (Card #1345) at F
PARKADE BOOM 2
[Out]
regards