Y
ytayta555
Hi all , and a good day
I have 2 ranges , with these values :
myRange1 =
(ROW) A B C
1 1 2 4
2 1 3 4
3 1 3 5
myRange2 =
(ROW) F G H
1 1 3 4
2 2 3 5
3 1 4 5
I need a macro to compare every cell in myRange2 - first row !! ,
with
every cell in myRange1 - first row !! , and , if tha value of every
cell in
myRange2 is equal with one of the cells of the first row of myRange1 ,
to
change the value with "QQQ" .
This must to be done in every row . After checking first row of
myRange2
with first row of myRange1 , to go to next row in myRange2 , and
compare
with the values of the next row of myRange1 . To compare row to row .
So , the results will became :
myRange1 =
(ROW) A B C
1 1 2 4
2 1 3 4
3 1 3 5
myRange2 =
(ROW) F G H
1 QQQ 3 QQQ
2 2 QQQ 5
3 QQQ 4 QQQ
Thank you in advance
I have 2 ranges , with these values :
myRange1 =
(ROW) A B C
1 1 2 4
2 1 3 4
3 1 3 5
myRange2 =
(ROW) F G H
1 1 3 4
2 2 3 5
3 1 4 5
I need a macro to compare every cell in myRange2 - first row !! ,
with
every cell in myRange1 - first row !! , and , if tha value of every
cell in
myRange2 is equal with one of the cells of the first row of myRange1 ,
to
change the value with "QQQ" .
This must to be done in every row . After checking first row of
myRange2
with first row of myRange1 , to go to next row in myRange2 , and
compare
with the values of the next row of myRange1 . To compare row to row .
So , the results will became :
myRange1 =
(ROW) A B C
1 1 2 4
2 1 3 4
3 1 3 5
myRange2 =
(ROW) F G H
1 QQQ 3 QQQ
2 2 QQQ 5
3 QQQ 4 QQQ
Thank you in advance