Sending individual sheets, retaining value but hiding formula and references.

[samualr2006]

Hi,

I am new to the forum and this is my first post.

I have an excel document that I use to calculate customer discounts for a range of products. The first sheet has my price list & discount structure, following sheets have specific pricing for each customer.

Every time there is a price increase I change the values on the first sheet which updates the following customer discount sheets update automatically. I then create PDF copies of each of these individual sheets and email them to the customers.

I have had a number of requests asking for the costing sheets to be sent through in an Excel format so they can work the the sheet and add any extra's in that they require. I am fine with this however I do not want to send them the entire document, just the sheet that applies to each customer.

Herein lies the problem. I can copy each sheet into a separate document but it still references the initial document and as soon as I send that out the link breaks (as it is stored locally) in the formula and the value in the cell disappears. How can i retain the value in the cell on the sheet while still using a formula in there? I would prefer if I can hide the formula in the cell as well.

I hope this explanation is not to confusing.

Any help would be much appreciated!

Cheers

Sam

[adyteo]

Copy the sheets in separate documents then select all (ctrl-A) and copy / paste as values. This will remove the links.

[bodnarj]

Do the copy/paste twice. Copy, then paste values onto the new sheet. Then, paste it again right over what you have just pasted - this time use paste formats. That way you also keep the 'look' of the sheet the same.