I Actually have a similar question, I have a Sheet where I have a Student Enrollment Form. I'd like to create a button that Allows me to duplicate a template from another Sheet (another document) in a new Spreadsheet and If possible fill out some information from the form. Would this be possible? I know nothing about macros or scripts tho :( Thanks!