I would like to request Experts help to extent of the search data function at Sheet 1 (DataUpdate). The current macro able to trace and displayed all data from Column D (MasterData workbook) based on entered data at cell C2 (DataUpdate).
The search function need to extent also at Column A and E from MasterData workbook. If any data entered in Cell C2 (DataUpdate sheet) and the data available in MasterData workbook (at column A, D oe E), the matched data will be displayed at DataUpdate sheet.
I have attached the workbooks for Experts perusal. Hope Experts will help me to add this additional function.