Creating a special macro

  • Thread starter Thread starter sbidaho
  • Start date Start date
S

sbidaho

What I am wanting to do is create a macro that automatically checks names in
a spreadsheet to find out if there are duplicates. I haven't written macros
in years and especially in 07.
Can anyone help?
 
There is an easy way to do this in 07. You go to conditional formatting,
press highlight cells rules, and go to duplicate values. It automatically
highlights the duplicates.
 
Do you want to delete duplicates ?

In 2007 this is a option on the Data tab
See Remove duplicates
 
On all sheets in the workbook or a particular one?

By "names" do you mean noun-like names or defined names?


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

upgrade macros to 07 7
Search OF Macros for a specific phrase 2
Macro - insert slashes into a cell 1
Excell 2000 macro will not open file! 1
Create a macro 1
Create Macro to pull data from a warehouse management system? 1
Excel 2007: Help creating a macro that will run Solver? 3
Repetitive macros 1

Back
Top