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ää: excel macro how to, loop macro vb, code vb text result soccer, loop macro multiple rows, excel macro cut paste based column value, vba add ins run macro, macro word table excel, vba outlook 2003 launch macro outlook close, loop macro count items spreadsheet, vba outlook mail start macro, excel vba open spreadsheet start macro

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