| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - Cut and paste a row if duplicate
Hello Everybody,
Can anybody help me with a macro which look up A1:F1000 and cut and paste and then delete the entire row which is a duplicate? For instance: If data in A1, B1, C1, D1.....F1 is repeating in A5, B5, C5, D5....F5, delete the entire row (5th row or 1st row based on the latest date). Date will be given in the column G. Thanks in advance -Dileep |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
| Cut and Paste using Macro gives paste special method error | Excel Programming | |||
| Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming | |||
| Macro to Copy/Paste then Paste to Next Line | Excel Programming | |||
Threaded Mode
