I need a button on an Excel 2007 sheet that will copy the contents of that entire sheet and then prompt the user to paste the contents (only values, formats, column width) to: 1) a new workbook, or 2) a sheet in a different workbook that is already open. The user will sometimes paste into a new workbook and sometimes into an existing workbook that is open, so both options #1 and #2 have to be available.
## Deliverables
Attached is a small sample file. I can send a larger test file if necessary.