Need a macro code for matching a data and copying multiple columns

Hi,

I have two tables :-


Table 1 :
--------------------------------------

Col 1 Col 2 Col 3

aaa
ccc
jjj



Table 2 :
-------------------------------------------

Col 1 Col 2 Col 3

aaa 1 2
bbb 3 4
ccc 5 6
ddd 7 8
eee 9 10
fff 11 12
ggg 13 14
hhh 15 16
iii 17 18
jjj 19 20

Now, i want to write a code which will search each entry present in Table 1 : Col 1 in Table 2: Col 1 and when a match is found, populate Table 1: Col2 with Table2:Col2 and Table 1:Col3 with Table 2: Col 3



Final output i am looking for would be :-

Table 1

-------------------------------------------

Col 1 Col 2 Col 3

aaa 1 2
ccc 5 6
jjj 19 20

Please attach a sample workbook with a desired result. To attach a sample, go to advance then attachment.

uploaded the file. thanks..the columns highlighted in yellow is the output i desire

Try the attached.

thanks a ton, works fine for the number of columns that i mentioned.

is there anyway i can modify the script so as to accomodate more columns in the future if the requirement changes.

Well, you can if you can. If not, send me a PM and will adjust for you.
For now please close the thread as solved.

attaching the actual file from my workspace.

i need to match ColE in Software Analysis sheet with ColA in MasterList sheet and populate ColF-ColJ in SoftwareAnalysis sheet with ColB-ColF of MasterList sheet if a match is found.

Try Attached.

Wow, this works great. You rock !!

Thanks a ton again.

Faiz,
You are welcome!