I have a workbook where i have 3 worksheets.
Sheet 1 Column A has the Consolidated List of information with mixed combination of Alpha Numeric Characters (All the 3 Sheets contains the Similar Data in Column A).
There is same kind of list information in Sheet 2 and Sheet 3.
My Requirement is, every time I will get a request to do the comparison between two or 3 files.
In order to avoid that, is there a way with Macro where we can perform the VLook up function through a click on a button or Something like that.
Please note that the Macro should work for the Dynamic Range in the Column A.
Is that Possible?
I want to give this them to avoid any type of comparison requests coming to me.
Suggest the best possible way.