Macro for allocation

That was great , only one small change you have divided based on the count of lines now if run teh macro it gives me 22 lines or 21 lines per person , but the name should be printed in sheet1 based on the sum of coloumn b divided equally among all the people.when some thing is more than average you can leave that coulmn blank. I have attached the file for reference.