Why cant I ?

  • Thread starter Thread starter nancy
  • Start date Start date
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?
 
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?
 
Back
Top