Instead of finding a value by the user input in InputBox, I have words already listed that I want to find and copy.
Sheet 1: I would want the result be pasted here
ProductID, Price, ReferenceID, other columns
Sheet2: I have List of ProductID and Price. The list of ProductID are the ones that may or may not be listed in Sheet3. I want to search the ProductsID in this sheet that matches ProductID in Sheet3.
Sheet3: I have List of ProductID and corresponding ReferenceID and other columns in which I want to copy all row for matching ProductID.
Thank you for your help!!!