Two rows comparison

[skitek]

Folks,

In my VBA programming New issue appeard. I was asked to create
"simple" macro that compares two rows - in two different worksheets
cell by cell, and if the value in two cells is the same in other row o
worksheet 2 certain value should be placed. Is there anybody who ca
help me.

thanks a lot

greetings

skite

 

[Bernie Deitrick]

Skitek,

We need a little more information: how are the rows determined, and how are
the sheets determined? Are they the same row number of each sheet, or is
there a key number in one column that must be matched. And what is and where
should the 'certain value' be placed?

Bernie
MS Excel MVP

 

[skitek]

rows are different size. From column number 2 on second sheet ever
number is looked in column - let me call it - number1. If it is matche
then it puts number from column next to column number 1 (but in the sam
line) to column that is next to column number 2 - also in the same line
So that every number from column two is looked in column number 1 an
certain value is given to every one of them.


thans aa lot

skite

 

[Bernie Deitrick]

skitek,

You're going to have to give us a before and after example.

HTH,
Bernie
MS Excel MVP