please help

[Don Guillett]

1. Please hep will often make people simply your request. Try a meaningful
subject line.
2. Please post in ONE newsgroup. You posted this in Excel. It is not a
charting question.
3. Is Kinky Ceasar really your name? I am a friend of Kinky Friedman. He
sang in my club and bought a station wagon from me.

 

[Kinky Caesar]

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

 

[Jeepin Sierras]

Highlight all the data that you want to send, and copy.
Then, select your new workbook and cell.
right click and select paste special,
on the options, select paste formats
then right click again and select paste special again,
and select paste values...
your data is now standalon

 

[GK]

Edit | Paste Special -- and check "values"