equations and comments don't transfer to new sheet

[~~single~~]

Hi,
I have an excell 2007 workbook that spans 10 years, has hundreds of rows and
columns, and many notes in cells relating to the line items. I want to
start a new workbook using the data from the last year. I mean I want to
take all of 2008, and in a new workbook label it 2009 and enter 2009 data as
it becomes available monthly. Trying to do this, I launched excel a second
time and then went to the sheet I want to copy into the new workbook. Using
control A I highlighted the desired sheet, and then went to the new
workbook, and then went to cell A1 and pasted it all into the new workbook.
All of the data came, but none of the logic or comments.
Is there a way to copy a sheet and keep it all, the data, the equations in
each cell, and the comments? If so, how can I do it?
Thanks in advance for taking the time to consider my question.
Al

 

[excel-ant]

Hi,
I have an excell 2007 workbook that spans 10 years, has hundreds of rows and
columns, and many notes in cells relating to the line items.  I want to
start a new workbook using the data from the last year.  I mean I want to
take all of 2008, and in a new workbook label it 2009 and enter 2009 dataas
it becomes available monthly.  Trying to do this, I launched excel a second
time and then went to the sheet I want to copy into the new workbook.  Using
control A I highlighted the desired sheet, and then went to the new
workbook, and then went to cell A1 and pasted it all into the new workbook.
All of the data came, but none of  the logic or comments.
Is there a way to copy a sheet and keep it all, the data, the equations in
each cell, and the comments?  If so, how can I do it?
Thanks in advance for taking the time to consider my question.
Al

Hi Al,

You need to perform a 'paste special'.
Edit > Paste Special
and then select which components you require.

You can keep pasting over formats, comments, column widths etc one
after the other to cuild up as you require.

Anthony
http://www.excel-ant.co.uk

 

[~~single~~]

Hey Anthony,
Thanks so much for the quick and concise reply.
Happy New Year.
Al

Hi,
I have an excell 2007 workbook that spans 10 years, has hundreds of rows
and
columns, and many notes in cells relating to the line items. I want to
start a new workbook using the data from the last year. I mean I want to
take all of 2008, and in a new workbook label it 2009 and enter 2009 data
as
it becomes available monthly. Trying to do this, I launched excel a second
time and then went to the sheet I want to copy into the new workbook.
Using
control A I highlighted the desired sheet, and then went to the new
workbook, and then went to cell A1 and pasted it all into the new
workbook.
All of the data came, but none of the logic or comments.
Is there a way to copy a sheet and keep it all, the data, the equations in
each cell, and the comments? If so, how can I do it?
Thanks in advance for taking the time to consider my question.
Al

Hi Al,

You need to perform a 'paste special'.
Edit > Paste Special
and then select which components you require.

You can keep pasting over formats, comments, column widths etc one
after the other to cuild up as you require.

Anthony
http://www.excel-ant.co.uk

 

[Shane Devenshire]

Hi,

Actually, your problem is not related to using Paste rather than Paste
Special. The problem is that you are opening a separate instance of Excel.
Instead of doing that try opening the second file in the same instance of
Excel and then do your copy and paste - regular copy, regular paste.

 

[Mike Middleton]

Al -

Is there a way to copy a sheet and keep it all, the data, the equations in
each cell, and the comments? If so, how can I do it?

Right-click the sheet tab (at the bottom of the Excel display), and choose
Move or Copy. In the Move or Copy dialog box, select To book: (new book),
check the box for Create a copy, and click OK.

Or, first create the new workbook, be sure it's open, and in your original
workbook follow the same steps above, but select your new workbook for the
To book: entry.

- Mike Middleton
http://www.MikeMiddleton.com
Software and Books for Decision Analysis and Data Analysis

 

[NickViv]

if you only have one worksheet in your workbook, the simplest solution
is: File =>SaveAs

- that creates an exact copy of ur original and closes it.

Rgds

Nick


http://www.excelexperts.com/
Free Excel based systems for the world