Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing Hidden But Keep Values
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 |
#2
|
|||
|
|||
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 "Wayne" wrote in message ... 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 |
#3
|
|||
|
|||
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 "Wayne" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
linked values in a chart | Charts and Charting in Excel | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) |