I am looking for a macro/ script that I can re-use in several excel spreadsheets.
The macro should do the following:
• Open second Tab of workbook
• For each Name in Column "A", find its match in the first tab "master" in Column "A"
• If a match is found then fill-in/ replace the data in the column D & E in the second tab with what is in column D&E in the first tab
• If there is no match for the name in the second tab, then write and add the Name, Freq and Alias to the third tab
Example is attached