Additional Field Added after Macro is Run

Good Morning All,

I have created a macro where a workbook will be created based on the a person's name in the 'PT NAME' Column. When I run the macro, it performs the functions perfectly, but I notice that Column 'AF' will appear with weird data that was never on master tab of the original file. Is there a way for that data not to appear on that column? I've attached the files below for your review and reference of what I am referring to. Thanks for your help and guidance.

I run your code using the debug tool, and it worked problem free. Didn't see any value in col AF.

Thanks 'Zekraoui', but it still appears on the file [i.e. Player 1's workbook]. Is there a code that I can maybe change? Once again, I appreciate the the help.

You can try this (a patch rather than a solution!), at the end of your code
range(af:af).select
selection.clearcontents
range("a1").select

Thanks, 'Zekraoui'! You're a genius! It worked! Now everything works smoothly! Thanks again!