From Excel. Create a new Macro. Paste this code in. Take a look at the code comments on where you may want to edit it for your needs