I need to see the workbook in order to review and understand the issue.
Would you be able to send me the file
Attachments are only available to registered users.
Ok I just got your email which was forwarded to me by JA customer service
So you want some kind of button on the 'Answer Sheet' which, when clicked, will generate a new sheet with a static copy of the data from the 'Answer Sheet'