How will I do this...Help me Please..

G

geeky

Help me with this.. I dont really have that much knowledge abou
excel...

I have a Record a Record that is in the Pivot table like this:

Item Code Serial
----------------------------------
Ques | 23120 | 00112255
| | 00112233


what i want to do is I want to inform the user that
one "Code" has multiple "Serial"... how will i create a macro
that will alarm the user that there is a duplication.

Thanks and more Power..
 
U

Udo

Hi geeky,

there are several simple methods to do something similar to what you
wanted without writing a macro. The easiest way would be to use Access
and make sure that the relevant fields are key fields. Then Access
would automatically not allow the user to enter a specific pair of data
multiple times.
If you need to use Excel, try it with the conditional formatting.
Proceeding: mark the area, for which this should be applied. Go to the
menu, chose Format - Conditional Formatting. In the leftmost cell, make
sure that the content is includes "formula", then in the next write the
following line: =countif(C$4$:C$30$; C4)>1
Here, C$4$:C$30$ is the area for which it is applied and C4 is the
first cell of that area. Then click on "Format..." and chose e.g. the
color red.
Then, whenever something is entered more than once into that area (and
the automatic calculation is switched on), the double entries are
marked in red.
I agree, that this is not exactly what you wanted, but it can be done
very quickly. If you insist to have either an automatic warning or a
pop up screen, which informs the user when opening the file that the
red color signals double entries, let me know.

regards and may the Power be with you....
Udo
 
Top