| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and paste duplicate data
Thank you Mr. Science. But we have to add some code to this.
Instead of deleting the entire row (myName.EntireRow.Delete), we have to look up Column H for A or B. If there is only one A, then delete the other column. If both are A, look up Column G and delete the oldest data (we have to check the latest date). Thanks in advance for any addition. -Dileep |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL PASTE DOES NOT CHANGE DATA - PASTE DOESN'T WORK! | Excel Worksheet Functions | |||
| Macro - Cut and paste a row if duplicate | Excel Programming | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| how can i locate duplicate data in an excel data table? | Excel Worksheet Functions | |||
| Scanning for Duplicate Data in a Column, Merging Data and Finally Removing All Duplicates...? | Excel Programming | |||
Hybrid Mode
