I have a data table that automatically opens with excel. What I am trying to do is when the user is finished entering thier data into the table and clicks on the close button it will automatically run that macro that I have already developed that sorts the data into the person's individual sheet and compiles that data into a group sheet.