Conducting Conditional Calculations

Originally Posted by DonkeyOte

Up to you how you play it but yes you can copy the contents of GT and run Paste Special -> Values over H at which point the values in GT become redundant...
as suggested I would still suggest you take a copy of the H2 cell before you do this so you have a roll back to your "default" value should you need it.

Genius, thanks for that, it worked perfectly. Ive done as you suggested and kept back the originals as a back up