Hello BobBridges,

Thanks for your response, it is greatly appreciated.

In regards to the basic excel functions, I have tried various things but have had no luck. Please tell me what features I can use, according to me the reason it does not work is simply because we have a fee which is a percentage of our selling price and then drives the cost up, hence the margin drops further.

I understand what you are saying in regards to getting it on every worksheet, but I am awful at excel and trying to learn, can you please help me with the code I should enter, and if you could kindly look at my other queries when you get a chance as they are more important.

Thanks.