Käynnissä

Vb macro for looping two worksheets

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?

Taidot: PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: loop macro, code text result soccer, loop macro multiple rows, macro word table excel

About the Employer:
( 6 reviews ) Jeddah, Saudi Arabia

Projektin tunnus: #8656264

Myönnetty käyttäjälle:

gokulanand

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

30 $ USD 1 päivässä
(38 arvostelua)
5.5