rsy
04-22-2018, 09:01 AM
Hi All,
I having problem in applying vlookup through vba. there are two dynamic workbooks whose data will be keep on changing which is Test.xlsm (i had created some codes in it) and second workbook is SAMPLENAME.xlsx.
there were few modification required in Test.xlsm which i did with the vba code. however after inserting columns in text.xlsm file, i required to apply vlookup in column D (after running previous codes) and needs to populate values corresponding to range A3 to last row from file SAMPLENAME.xlsx column 2 i.e values present in "Zone" column.
Basically in both file "Dealer name" is common and I need to bring "Zone" against each "dealer name" from SAMPLENAME.xlsx into Test.xlsm file.
both file attached. and data in both file will be dyanamic so i'm looking for formula that may work in any data range condition.
I tried to do but getting so many errors. Please see if any one can help me out.
I having problem in applying vlookup through vba. there are two dynamic workbooks whose data will be keep on changing which is Test.xlsm (i had created some codes in it) and second workbook is SAMPLENAME.xlsx.
there were few modification required in Test.xlsm which i did with the vba code. however after inserting columns in text.xlsm file, i required to apply vlookup in column D (after running previous codes) and needs to populate values corresponding to range A3 to last row from file SAMPLENAME.xlsx column 2 i.e values present in "Zone" column.
Basically in both file "Dealer name" is common and I need to bring "Zone" against each "dealer name" from SAMPLENAME.xlsx into Test.xlsm file.
both file attached. and data in both file will be dyanamic so i'm looking for formula that may work in any data range condition.
I tried to do but getting so many errors. Please see if any one can help me out.