I have code in module1 and code on the sheet "Sheet1". The code in module1 will have the user select the current months spreadsheet and then copy of the data into this spreadsheet. After it has been copied I am attempting to split the sheet into multiple workbooks based on the table in sheet "Names". The code attached to sheet "Sheet1" works up to the point where I added the code to update the format of the new spreadsheet. I would like for the user to only have to select 1 macro and then the file name, but I am not sure how to do it. Thanks in advance for any assistance.