VBA - Seperating Column data based on Criteria.....

[malleshg24]

Hi Team,


Need your help,


From Column (Score ) Whenever you find First 50000 from top to Bottom, Seperate the row
by adding two blank row on above that row and give border to line on below row.


Next Challenge,
if I have players name in Column A, but Runs not available in Column B , Seprate those players
by adding two blank row above of that row. and border one line
Needs to cover both the the situation, I have added input files , expected result in output file,

Thanks in advance for help.


Regards,
mg