Advertisement

11.14.2007 at 03:21AM PST, ID: 22959574
[x]
Attachment Details

Deleting and/or colouring duplicates

Asked by Lars_H in Microsoft Excel Spreadsheet Software

I use Microsoft office excel professional edition 2003.

This is what I need to accomplish.

I have a list of value (may be text or number) in column A, and I need to delete the duplications. This is easily accomplished with a macro.

However:

I would like to have four command Buttons in the worksheet.

Command Button number one: Deletes entire row when there are duplicates in column A. And it is not case sensitive.

Command Button number two: Colours entire row red when there are duplicates in column A. And it is not case sensitive.

Command Button number three: Deletes entire row when there are duplicates in column A. And it is case sensitive.

Command Button number four: Colours entire row red when there are duplicates in column A. And it is case sensitive.

I have accomplished to get first command button number one to work, but as soon I try to make more than one macro (and have different command Buttons), nothing works.

Thanks for any help.
Start Free Trial
[+][-]11.14.2007 at 03:43AM PST, ID: 20279116

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.14.2007 at 03:47AM PST, ID: 20279127

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.14.2007 at 03:48AM PST, ID: 20279131

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.14.2007 at 03:49AM PST, ID: 20279140

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.14.2007 at 04:26AM PST, ID: 20279307

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Sign Up Now!
Solution Provided By: macsek
Participating Experts: 3
Solution Grade: A
 
 
[+][-]11.14.2007 at 04:28AM PST, ID: 20279311

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.14.2007 at 06:04AM PST, ID: 20279879

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.14.2007 at 08:25AM PST, ID: 20281187

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628