Advanced Excel Macro to replace database values

Create an excel macro to replace server names in a database extract. The macro needs to modify relationships by searching for old server names and replacing it with new server names. The new servers need to be then assigned a unique identifier number if one exists or marked as Missing if not available in the database server list. The macro needs to be fine-tuned to deal with heavy data (100000R * 7C) + (300000R * 52C). Very advanced knowledge of Excel, Visual Basic, Macros, SQL, Data Analysis, Widows API required. Only advanced coders, no beginners please.