gclifton, please use VBA code tags to wrap your code.

On your question, can you attach a sample workbook with pre and post examples. That will make it easy for a developer to create a macro for you.