mrfrid
01-13-2016, 03:39 AM
Hi,
i'm not very good with vba, so i hope someone can help me with a macro that compares 2 values and write a string.
1. It shall compare the values from sheet 1 (column B) with sheet 2 (column B).
2. If it finds same value in sheet 1 and sheet 2 (column B) then it shall compare the values from sheet 1 (column C and D) with same columns in sheet 2 (column C and D) .
3. Now it shall publish "Right Price", if its same values from column C and D and "Wrong Price" if its not same values from column C and D. It shall publish this in sheet 2, column G and column H.
There can be everything from 100 to 100000 rows in the file, so i need it to loop throw entire sheets.
Hope someone can help me with this, and if there are any doubt, please let me know so will i try to explain a little more.
example from sheet 1:
A
B
C
D
E
F
NoN Download
012888
29
28
SE
Netonnet
NoN Download
013004
139
136
SE
Netonnet
NoN Download
013006
179
175
SE
Netonnet
NoN Download
013451
179
175
SE
Netonnet
NoN Download
013452
249
244
SE
Netonnet
NoN Download
013453
179
175
SE
Netonnet
NoN Download
013660
199
195
SE
Netonnet
NoN Download
013667
99
97
SE
Netonnet
NoN Download
013669
89
87
SE
Netonnet
NoN Download
013671
99
97
SE
Netonnet
NoN Download
013673
99
97
SE
Netonnet
NoN Download
013676
449
440
SE
Netonnet
NoN Download
013678
99
97
SE
Netonnet
NoN Download
013679
99
97
SE
Netonnet
Example sheet 2:
A
B
C
D
E
F
G H
PDCI
195809
2690
2636
SE
Netonnet
PDCI
195811
2690
2636
SE
Netonnet
PDCI
195821
3790
3714
SE
Netonnet
PDCI
195833
3490
3420
SE
Netonnet
PDCI
195835
3490
3420
SE
Netonnet
PDCI
195849
4790
4694
SE
Netonnet
PDCI
195851
4790
4694
SE
Netonnet
PDCI
195853
4990
4890
SE
Netonnet
PDCI
195855
4990
4890
SE
Netonnet
i'm not very good with vba, so i hope someone can help me with a macro that compares 2 values and write a string.
1. It shall compare the values from sheet 1 (column B) with sheet 2 (column B).
2. If it finds same value in sheet 1 and sheet 2 (column B) then it shall compare the values from sheet 1 (column C and D) with same columns in sheet 2 (column C and D) .
3. Now it shall publish "Right Price", if its same values from column C and D and "Wrong Price" if its not same values from column C and D. It shall publish this in sheet 2, column G and column H.
There can be everything from 100 to 100000 rows in the file, so i need it to loop throw entire sheets.
Hope someone can help me with this, and if there are any doubt, please let me know so will i try to explain a little more.
example from sheet 1:
A
B
C
D
E
F
NoN Download
012888
29
28
SE
Netonnet
NoN Download
013004
139
136
SE
Netonnet
NoN Download
013006
179
175
SE
Netonnet
NoN Download
013451
179
175
SE
Netonnet
NoN Download
013452
249
244
SE
Netonnet
NoN Download
013453
179
175
SE
Netonnet
NoN Download
013660
199
195
SE
Netonnet
NoN Download
013667
99
97
SE
Netonnet
NoN Download
013669
89
87
SE
Netonnet
NoN Download
013671
99
97
SE
Netonnet
NoN Download
013673
99
97
SE
Netonnet
NoN Download
013676
449
440
SE
Netonnet
NoN Download
013678
99
97
SE
Netonnet
NoN Download
013679
99
97
SE
Netonnet
Example sheet 2:
A
B
C
D
E
F
G H
PDCI
195809
2690
2636
SE
Netonnet
PDCI
195811
2690
2636
SE
Netonnet
PDCI
195821
3790
3714
SE
Netonnet
PDCI
195833
3490
3420
SE
Netonnet
PDCI
195835
3490
3420
SE
Netonnet
PDCI
195849
4790
4694
SE
Netonnet
PDCI
195851
4790
4694
SE
Netonnet
PDCI
195853
4990
4890
SE
Netonnet
PDCI
195855
4990
4890
SE
Netonnet