all files are located in a same place
vba code will be placed in a macro.xlsm
my first file name is 1.xlsx
my second file name is 2.xlsx
open both the files
in 1.xlsx column A consist of stock name and 1.xlsx has headers in the first row
In 2.xlsx column B consist of stock name and 2.xlsx has headers in the first row
see the pic which i attached
now what i need match column A stock name of 1.xlsx with column B of 2. xlsx and if it matches then copy the yellow highlighted colured cell data in that row of 1.xlsx and paste it to column L OF 2.xlsx
save and close both the file after doing the process
So plz help me sir in solving this problem sir




Reply With Quote

Bookmarks