Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2013, 08:36 PM
macropod's Avatar
macropod macropod is offline Consolidate names Windows 7 64bit Consolidate names Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


Updated workbook attached. I had to make a few minor changes to the macro because your file has content other than just the data rows. I also added a progress report that appears on the status bar. To run the macro press Alt-F8 select 'DeleteDuplicates', then OK.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
consolidate, duplicates, list



Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidate names matching names in column A with names in column C bob999999 Excel 1 04-28-2013 11:21 AM
Consolidate - does not work in 2007 version Jirik61 Excel Programming 10 08-08-2012 04:59 AM
names on bars Psychopig7 Project 1 06-22-2012 04:58 AM
How to enter names in Resource Pool/names pstein Project 1 03-26-2012 07:37 AM
Names dguillory Word 0 12-29-2009 11:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft