Why cant I ?

N

nancy

When I try to copy a monthly end figures of a file
Why cant I copy the last row and then past it to a new excel sheet?
Keep in mind I am a baby at this and it took me 6 months to do a monthly spread sheet and I have worked with it all this past 12 months entering not building. HElp HeLp
I want to make a spread sheet of these last 12 months so I can calculate the changes from before.
Can someone help me?
 
N

Niek Otten

You can. But just paste the values, not the formulas; Edit>Paste special, check Values

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

When I try to copy a monthly end figures of a file
Why cant I copy the last row and then past it to a new excel sheet?
Keep in mind I am a baby at this and it took me 6 months to do a monthly spread sheet and I have worked with it all this past 12 months entering not building. HElp HeLp
I want to make a spread sheet of these last 12 months so I can calculate the changes from before.
Can someone help me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How To Rapidly Copy Formulas? 0
cannot find which label format i need 1
same formula and cells for different worksheets 1
Need Help with a VBA subroutine 0
Formula to fill cells based on Date of Arrival and Date of Departure 1
Linking Cell based on Date 8
Problem with Excel Dates 21
Pages are changing pasted image... 0

Top