Shg, It appears you have not read my description properly. I have de-sensitised data so yes for this example I could do this without using macro... HOWEVER, for the actual spreadsheet I need to apply this to, I CANNOT! I must use a VBA. The spreadsheet contains multiple rows and collumns of calculations and adjustments to the Input value before giving the final output value. All this must stay as is with the formatting. THUS I require a simple macro to do the task that I have explained!

Regards,

Spicey