VBA Apply autofilter and then do Vlookup from another sheet

  • Hi,


    I tried searching for this but unable to find any solution. I even posted this on another forum and no one replied.
    Link : https://www.mrexcel.com/forum/…r-then-apply-vlookup.html




    I have a sheet "Working IC" which has some 50+ columns (starting from row 5th) and I created a remarks column in "AZ" column first.
    Then I applied autofilter with a criteria on column no 48 ( I will apply another filter and will do the same vlookup operation again on that)
    I have another workbook open (MacroRUN.xlsm) which has two sheets "Party Name" and "Line Description". I will be using the data from these worksheets in "Working IC" sheet.


    So from column 48, I will pick up all the filtered values one by one and apply vlookup to compare them from the "Party Name" and "Line Description" worksheets open in another workbook.
    And on column "AZ" I want them to come one by one as per the vlookup values. But something is going on wrong and need your help on this.


    Here is the code:


  • Re: VBA Apply autofilter and then do Vlookup from another sheet


    I tried to change some coding but still no luck !
    Anyone?


    Here it is:



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!