there are two files file name sample1.xlsx & sample2.xlsx
vba will be placed in a seperate file macro.xlsm
sample1.xlsx is located at C:\Users\WolfieeeStyle\Desktop
sample2.xlsx is located at C:\Users\WolfieeeStyle\Desktop\Upstox
macro.xlsm is located at C:\Users\WolfieeeStyle\Desktop
only macro.xlsm file is opened so we have to open rest 2 file by vba
If column H of sample2.xlsx matches with Column D then look column B data of sample2.xlsx and find that data in sample1.xlsx in column B and after getting that data in sample1.xlsx in column B , copy that entire row of sample1.xlsx and paste that in sample2.xlsx in the same row
all this is have to do by vba
so plz have a look into this problem and help me in solving this problem sir
sheet name can be anything
vba will be placed in a seperate file macro.xlsm
sample1.xlsx is located at C:\Users\WolfieeeStyle\Desktop
sample2.xlsx is located at C:\Users\WolfieeeStyle\Desktop\Upstox
macro.xlsm is located at C:\Users\WolfieeeStyle\Desktop
only macro.xlsm file is opened so we have to open rest 2 file by vba
If column H of sample2.xlsx matches with Column D then look column B data of sample2.xlsx and find that data in sample1.xlsx in column B and after getting that data in sample1.xlsx in column B , copy that entire row of sample1.xlsx and paste that in sample2.xlsx in the same row
all this is have to do by vba
so plz have a look into this problem and help me in solving this problem sir
sheet name can be anything