HI All

I am new to macros. But i urgently require a macro the pulls the specific columns data from one workbook and paste it in another workbook

Eg
source file:
column 1 cloumn2
talent ge
dfgr
dfgdf
gsdfg dkf
jdhkdj

target file should be like
column1 column2
talent it should be a drop down containing all the corresponding to talent
gsdfg similarly this one

please reply as soon as possible thanks in advance