inlineside-by-sideside-by-side markdown
Excel macro Macro to loop through 2 two worksheets
As the following I have 2 two worksheets, in each one there is a table like this:
Worksheet1
A B C
1 John 10 A
2 John 20 B
3 Bill 100 X
4 Bill 200 Y
5 Tom 100 Z
Worksheet2
A B
1 John X1
2 John X2
3 Bill Y1
The result:
A B C D
1 John 10 A X1
2 John 10 A X2
3 John 20 B X1
4 John 20 B X2
5 Bill 100 X Y1
6 Bill 200 Y Y1
....
....
So for each row in worksheet1 it will check the same value of column A in worksheet2 and will make the multiplication.
How to achieve that as a VB macro VBA in excel Excel?
Hello Eshta,
I can get this task done using VBA macro with in the next 2 to 4 hours. We have worked together before. Please lelt me know if you are interested.
Thanks