Removing Hidden But Keep Values

W

Wayne

Hi!

A client gave me an Excel spreadsheet (Excel 2002), with
a request for me to fill in the prices of various items
in his list.

I am a contractor, and jobbed out some items to various
sub contractors, and asked them to fill in the values of
the original spreadsheet, and send it back to me.

Now I need to convert from per unit to per thousand, and
add my mark-ups to the spreadsheet. I understand the
basic formula's, but I want some way to be able to hide
my calculations and mark-ups from my client, and give him
back the spread sheet.

Obviously the guy is smart enough to "Show hidden columns
and rows", how can I get around this and only give
him "clean" data.

TIA - Wayne/Graphico 6191
 
C

CarlosAntenna

Since he gave you a spreadsheet to fill in, I'm guessing he is expecting to
get a spreadsheet back rather than a PDF file. So....

Make a copy of the sheet, do your calculations, copy from the new sheet and
Paste Special > Values into the original sheet then delete the calculation
sheet before returning it to the client.

Carlos
 
G

Guest

Thank-You Sr.Carlos!
-----Original Message-----
Since he gave you a spreadsheet to fill in, I'm guessing he is expecting to
get a spreadsheet back rather than a PDF file. So....

Make a copy of the sheet, do your calculations, copy from the new sheet and
Paste Special > Values into the original sheet then delete the calculation
sheet before returning it to the client.

Carlos




.
Click to expand...
 
Top