I guess I should have been more specific. I am in charge of company templates. An upcoming project is going to require updated templates but those templates cannot be put in place until after the project has officially started. I am going to be out of office at this time and unable to to upload the new files, therefore I want to develop and automatic file copy based on a chosen input date. Please keep in mind that I am a novice and only have a rudimentary understanding of VBA.