Thank you seasider89! You're a life saver

I managed to figure out how to add macros and added the code that you gave. Works like a charm.

One small problem, every time I open the file now, there is this new pop-up, that warns me that the workbook contains macros. How do I automatically enable macros without having to click "enable macros" every time I open the excel file?

Thank you once again seasider89.