PLEASE! How do i cut and paste sheet5 with out loosing all the values on it (that were formulated fr

  • Thread starter Thread starter The Grinch
  • Start date Start date
T

The Grinch

select what you want to copy and paste, press ctrl c, then select wher
you want to past, then go edit -> paste special, then select "values"
then click ok.

This will only paste the actually values of the calculated formulae
 
Dear All

I Hope you can help me please, i have made up my price list for my business
on excel .
sheets 1 to 3 are materials and they are all added up together on sheet 4.
(sheet 4 giving me my final materials cost)

now sheet 5 is my costs plus profit. this is all fine now my problem is.

i would like to cut and paste sheet 5 on to an other folder so i can email
it to clients.

But when i do this most of the values disappear as i have broken the formlas
to give those values,

so can some please help me and tell me how i can, cut and paste so i have
just my price list with all the values on it.

cheers i will be very greatful for any suggestions.

Best wishes

Charles
 
Back
Top