help please

19/07/2004 - 19:02 por Kinky Caesar | Informe spam
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
 

Leer las respuestas

#1 Fernando Gomez
19/07/2004 - 20:08 | Informe spam
Tienes dos opciones:
1. Copiar y paster solo valores
Seleccionar la informacion ==> Edit ==> Copiar
posicionate en la hoja a pastear==> Editar ==> Pasteado Especial ==> Pastear
==>Valores

2 Copiar la hoja entera
Clickar derecha en pestaña de hoja ==> Mover o Copiar
A Libro ==>Puedes crear un nuevo libro o agregarlo de inmediato al libro
donde quieres la informacion
Clicka en la esquina superior izquierda de la hoja (Se selecciona por
completo la hoja ==> Editar ==> Copiar
Editar ==> Pasteado Especial
Pastear ==> Valores


Clickar Crear copia (Esquina inferior izquierda)
"Kinky Caesar" wrote in message
news:w8TKc.609$


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


Preguntas similares