Hi I am a bit rubbish with Macros and when I ran this one o my data it changed all the percentages I had in one column to either 100% or 0%. Not sure if I did something wrong!