please help

  • Thread starter Thread starter Don Guillett
  • Start date Start date
D

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.
 
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
 
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
 
select the top row of data with formulas in it and name
it "formulas". Then select rows 2 down to the end and
edit, copy,edit, paste special, values.

Now cut and paste the values into a document for your
customer.

Finally, select the range "formulas, edit, copy. Then
select rows 2 down to the end and edit, paste.

This reinstates your formulas.

All this can be automated in 2 simple macros.

Hope this helps.
 
Back
Top