The table forms part of a progress report and the values in columns 3 and 4 are pasted in from another programme, reporting on the planned vs actual percentage of task completion.



I have had to go through each cell and manually copy/paste the % symbol to the end of each value.

The table is quite small just now, but the macro will save me a lot of time when the project progresses and additional tasks are added.

I hope to be able to edit the macro myself to include text formatting.

Regards
Dawsie