Hi Robert,

I think I do need the macro, as there will already be data in column F. When I make changes to Column G (Which flows through from another sheet), I need to then permanently record the change in Column F, hence the copy and paste special values element.

Cheers,

Starkey