Dan the Man wrote:
I have a new spreadsheet that I created entitled "Evaluation Outcomes", and
I'd like to copy and paste it into an existing spreadsheet (entitled Master
Database-different book), however when I attempt this I get a message
advising me that data on the clipboard is not of the same size and shape.
Thus, if I paste the page it does not provide me with a copy that is the same
in dimensions. Even worse, I lose all my forumulas in the process. Any
solutions to obtain an exact copy (including formulas) without having to
reset all my rows and columns by hand?



Thanks in advance,

Dan

Open both workbooks. Select your "Evaluation Outcomes" workbook. Choose
Edit | Move or Copy Sheet, and point to the other workbook. Make sure
you tick the option to "Create a copy".

Note if you have formulae in the original worksheet that refer to other
worksheets in the original workbook, the copied version will link to the
original workbook.