I have a workbook with two worksheets 1 and 2 (with lot or rows and columns). Let's give an example:
Sheet 1
Column A Col B
10
20
30
30
10
30
Sheet 2:
Col A Col. E
10 1000
20 2000
30 3000
I want to write a macro so I can plug in the corresponding data from Column E of sheets 2 into all the cells in column B of sheet 1 (Ex: If cell A1 of sheet 1 is 10, 1000 will be inserted into cell A2 of sheet 1. Iif cell B1 is 20, then 2000 will be inserted into cell B2 of sheet 1, etc.
Thanks for your help.
Sheet 1
Column A Col B
10
20
30
30
10
30
Sheet 2:
Col A Col. E
10 1000
20 2000
30 3000
I want to write a macro so I can plug in the corresponding data from Column E of sheets 2 into all the cells in column B of sheet 1 (Ex: If cell A1 of sheet 1 is 10, 1000 will be inserted into cell A2 of sheet 1. Iif cell B1 is 20, then 2000 will be inserted into cell B2 of sheet 1, etc.
Thanks for your help.