Price Control for Distinct Product Codes

Hello everyone,

First of all, thanks for all the helpful posts for beginner excel users.

Here is my problem:

I am trying to create a macro button which checks whether a price of a product is same for its every other size (S, M, L, XL etc.)

When I click the macro button (named "Check Prices"), it should check for prices and if it finds a different price for different sizes for the same product, it should prompt the message box: "Please check your prices."

For example "Product A" has four sizes: S, M, L, XL and all sizes should have the same cost, retail price and sale price.

I uploaded an attachment to work on it.

Actually I have tried the code which I created below but I couldn't manage to create a MsgBox if a duplicate value found in a specified range. I am sure there is a better way without creating extra columns etc.

Please Login or Register  to view this content.

Aprreciate the help and sorry for basic English.

Hi Quanom. Try this (if I understand correctly)

Please Login or Register  to view this content.

nilem The code you provided works like a charm!

Well it is a little annoying because I strived about three hours for this

I couldn't even understand most of your code but I am a beginner after all.

I will try to understand the code later this evening.

One more question:

Is there a way to make red colored all of the prices of the wrong priced product? Because one can't know which price is wrong. You have to check them both.

Thank you very much for the help.

Originally Posted by quanom

...Is there a way to make red colored all of the prices of the wrong priced product?

try it

Please Login or Register  to view this content.

New code highlights the different price and the first price (which is at upper row) of the product; not all prices.

For example;

IF

S -> 59 $
M -> 59 $
L -> 59 $
XL -> 69 $

Then it will highlight the S and XL prices.

But it is better than the first one for sure.

Thanks for quick reply man.

option number three

Please Login or Register  to view this content.

there are simpler options

Perfect! I hope someone else can utilize this code too.