title: Replacing text in excel from a static table
body: <p>I have a report that is sent to me daily that only supplies IP addresses and would like to create a macro that would look up the address to host conversion from another table (external to the excel sheet report). So that when its executed, the IP address would be replaced with the actual hostname. </p>
  
  <pre><code>Date/Time Detected    Source IP Address       Destination IP Address
  6/19/2013 15:46       172.16.16.40            172.16.4.10
  6/19/2013 15:46       172.16.16.40             *
  6/19/2013 15:02       172.16.16.40             *
  6/19/2013 15:02       172.16.16.40             *
  6/19/2013 15:02       172.16.16.40             *
  6/19/2013 15:02       172.16.16.40             *
  </code></pre>
  
  <p>In this example, I would have a table that would have an IP address and Host address (from a dns export table), that I would like to do a replace Source IP with it's hostname from my daily reports.  The dns table is static, the daily reports would be populated with a replace IP with hostname from the static dns table.</p>