I am trying to create a macro which would do a similar vlookup between any given two excel sheets.
Eg. - I have been doing a vlookup of a particular data everyday on our BAU files. i.e. I work today on 01/02/2017.xlsx tommorrow I have to do a vlookup on 02/02/2017.xlsx against 01/02/2017.xlsx to get the data from yesterdays file and identify new cases and the same thing is repeated everyday.
I need help in creating a macro that could solve this problem by creating a button (macro enabled) and creating a hyperlink of two excels, where i can insert any two days excel and the vlookup is taken care automatically.
Currently, I am just able to do a vlookup between particular excels using macro but not sure how to do the same vlookup on different sheets using macro.
Kindly advice.