Copy/Paste the event code into that code window. This will open up the code window for that worksheet.
To install it, right-click the name tab at the bottom of the worksheet that is to have the functionality to be provided by the event code and select 'View Code' from the popup menu that appears. If you are new to event code procedures, they are easy to install. Here is instruction on how to install event code. you don't run it, it runs automatically in response to an action by the user (in this case, a change to cell values). Click to expand.Frank did not give you a macro, rather, he gave you event code.
