| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro that copies and pastes
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A Macro that Copies from Excel & Pastes into a webpage | Excel Discussion (Misc queries) | |||
| How do I set up a querry that copies and pastes | Excel Programming | |||
| A macro that copies and pastes autofiltered cells will fail. | Excel Programming | |||
| Copies 02/22/2005, Pastes 02/21/2001 | Excel Worksheet Functions | |||
| change a macro so that it copies and pastes data as values rather than references | Excel Programming | |||
Threaded Mode
