Help with Macros in Exel

  • Thread starter Thread starter Narce
  • Start date Start date
N

Narce

I need some help to make my little project work. !! Any help is very
appreciated

What I want the macros to do ?

Compare cells A2:A28 with cells B2:B28

It should first check cell A2 to see if a matching value in found inthe
range of cells B2:B28
Should make a Z in C2 if a matching value in found in the range of cells
B2:B28. This is the case, found it in B2, so it makes a Z in C2 (see the
example)
Should make a Z in C3 if a matching value in found in the range of cells
B2:B28. This is the case, found it in B13, so it makes a Z in C3 (see the
example)
Should make an N in C4 if a non-matching value in found in the range of
cells B2:B28. This is the case, it did not find it, so it makes a N in C4
(see the example)

This checking should be made for every value from cell A2 to A28


A B C
0517684287 0517684287 Z
0517685100 517685109 Z
517543288 517543288 N
517543433 517543332
517543403 517543403
517543424 517543424
517543332 517555288
517543456 517555403
517544100 517552274
517544288 5175522
517544334 517552403
517544403 517545100
517544409 517545288
517544423 517553100
517544450 517553332
517560334 517553403
517560691 517553456
517551100 0517685100
517551274 517554274
517551334 517554288
517551403 517554403
517551523 517578403
517551682 517578682
517551691 517686100
517550274 517686274
517550332 517686334
517550403 517686403
517550691 517686691


Thanks in advance,
Narce
 
You've posted to a newsgroup for ACCESS, the database program. I recommend
that you post to one of the EXCEL groups.
 
Back
Top