Quote Originally Posted by hri1428 View Post
I'm relatively new to excel and I'm not sure how to enter that information into Excel. I have never used VBA before.
If you are new to VBA, your best bet is to post a sample of your workbook so we can see your formatting and layout. This is important because it will help us trap for errors and troubleshoot any potential problems before they occur.

If you would prefer to just put the code in yourself, right click on the sheet tab that you want the code to be applied to (ie, Sheet1). One of the options should be View Code. Once you click that, the VBE will open up and a dialog box will have the focus. Simply copy and paste my code into the dialog box.

Let me know if it works.