| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate deleting duplicate rows
In Excel 2000, is there a way to write a macro or something to automate the
deletion of duplicate rows in the spreadsheet? I'm new to visual basic, and any help would be much appreciated. I delete dup rows on a weekly basis and I'd like to try to save some time and be more accurate. Thank you for your time... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automate deleting duplicate rows
DataFilterAdvanced Filter
it has a unique rows facility. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CMIConnie" wrote in message ... In Excel 2000, is there a way to write a macro or something to automate the deletion of duplicate rows in the spreadsheet? I'm new to visual basic, and any help would be much appreciated. I delete dup rows on a weekly basis and I'd like to try to save some time and be more accurate. Thank you for your time... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automate deleting duplicate rows
I do not see the unique rows facility...
"Bob Phillips" wrote: DataFilterAdvanced Filter it has a unique rows facility. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CMIConnie" wrote in message ... In Excel 2000, is there a way to write a macro or something to automate the deletion of duplicate rows in the spreadsheet? I'm new to visual basic, and any help would be much appreciated. I delete dup rows on a weekly basis and I'd like to try to save some time and be more accurate. Thank you for your time... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automate deleting duplicate rows
Okay... I found it. I've never used advanced filter, so I will play around
with it. Thanks :) "Bob Phillips" wrote: DataFilterAdvanced Filter it has a unique rows facility. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CMIConnie" wrote in message ... In Excel 2000, is there a way to write a macro or something to automate the deletion of duplicate rows in the spreadsheet? I'm new to visual basic, and any help would be much appreciated. I delete dup rows on a weekly basis and I'd like to try to save some time and be more accurate. Thank you for your time... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help on deleting rows . Please see inside. | Excel Discussion (Misc queries) | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
| How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
| Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
