Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove the formulae, but keep the data
I have an "entry" sheet which feeds a "Finished" sheet. I want to send the
finished one to a client without revealing how I came up with the numbers. How do I delete the formulae, but keep the data? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove the formulae, but keep the data
Hi Dave
You can copy and Paste Special as values The best thing to do is to make a new workbook with that sheet so your original workbook will stay the same. You can do it with a macro or use my mail add-in Try the add-in http://www.rondebruin.nl/mail/add-in.htm If you want to do it manual post back -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Womack" wrote in message ... I have an "entry" sheet which feeds a "Finished" sheet. I want to send the finished one to a client without revealing how I came up with the numbers. How do I delete the formulae, but keep the data? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove the formulae, but keep the data
Select your formula hit F2 hit F9
"Dave Womack" wrote: I have an "entry" sheet which feeds a "Finished" sheet. I want to send the finished one to a client without revealing how I came up with the numbers. How do I delete the formulae, but keep the data? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove the formulae, but keep the data
"Teethless mama" wrote: Select your formula hit F2 hit F9 "Dave Womack" wrote: I have an "entry" sheet which feeds a "Finished" sheet. I want to send the finished one to a client without revealing how I came up with the numbers. How do I delete the formulae, but keep the data? Thanks. this in not exactly what I was looking for, but a neat trick. I really appreciate your quick response. Ron (above) gave me what I was looking for. Dave |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove the formulae, but keep the data
Perfect....that's what I needed. You rock.
Dave "Ron de Bruin" wrote: Hi Dave You can copy and Paste Special as values The best thing to do is to make a new workbook with that sheet so your original workbook will stay the same. You can do it with a macro or use my mail add-in Try the add-in http://www.rondebruin.nl/mail/add-in.htm If you want to do it manual post back -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Womack" wrote in message ... I have an "entry" sheet which feeds a "Finished" sheet. I want to send the finished one to a client without revealing how I came up with the numbers. How do I delete the formulae, but keep the data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validate data using formulae | Excel Worksheet Functions | |||
Sorting data, but not the formulae | Excel Worksheet Functions | |||
Deleting the DATA but NOT the Formulae! | Excel Discussion (Misc queries) | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |