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?

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?

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?

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

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?