Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Assistance please.
Excel Guri
Good people, I am trying to set up a Excel macro that will look at a time value that has to run in a sequence of three. If there is only one occasion on the particular day the entire row is to be deleted row. A small example follows. Can you assist with the code please. A B C D E F G H DELETE 1 20/3/05 1 4:37 MELBOURNE 2 12 3 DELETE 2 20/3/05 1 4:15 BALLINA 6 2 3 DELETE 3 20/3/05 1 4:15 BALLINA 6 6 5 RETAIN 4 19/3/05 7 4:37 TOOWOOMBA 2 5 4 RETAIN 5 19/3/05 7 4:37 TOOWOOMBA 2 8 8 RETAIN 6 19/3/05 7 4:37 TOOWOOMBA 2 9 0 DELETE 7 19/3/05 7 5:15 TOOWOOMBA 3 2 2 DELETE 8 19/3/05 7 5:15 TOOWOOMBA 3 3 2 DELETE 9 19/3/05 7 1:15 BRISBANE 2 3 2 DELETE 10 19/3/05 7 1:15 BRISBANE 2 8 3 RETAIN 11 19/3/05 7 1:05 GEELONG 2 2 2 RETAIN 12 19/3/05 7 1:05 GEELONG 2 3 8 RETAIN 13 19/3/05 7 1:05 GEELONG 2 5 0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assistance need with excel doc | New Users to Excel | |||
Assistance with password in Excel | Excel Worksheet Functions | |||
How can I get assistance on Excel Formula? | Excel Worksheet Functions | |||
1-2-3 @ function to Excel Assistance | Excel Worksheet Functions | |||
Excel VBA assistance for a noobie | Excel Programming |