p45cal, I ran your file and although it works, it's not exactly what I need the sort to do. I'll see if I can explain it simply. When the data gets sorted and put into the GAMES sheet, the new entry goes where it's suppose to and then every entry after that moves down one row until it gets to row 50 in which the entry that was at row 50 gets moved to the top of row 1. The last entry that is in row 50 column J/K gets moved to row 51 column A/B and everything repeats itself until row 100 and then repeats itself again every 50 rows until it gets to the end. Right now if I add an entry ASTRO CHAS 777b and sort it, it puts it before the two ASTRO CHASE entries but nothing gets moved. It should move the second ASTRO CHASE 187B up to row 1 column J/K and the entry that was at row 50 column J/K(BASEBALL 637B) should get moved to row 51, column A/B.



The last file that NoSparks posted did that so maybe you could take a look at his and see what he did to understand what I need. Other than that your way seems simpler and easier to work with especially for future files.



Something just occurred, maybe I'm doing the sort wrong in the editme sheet. What I am doing is adding an entry which is ASTRO CHAS 777B, then clicking on sort which a drop down comes up asking me how to sort it. Column A? Well, I need to have column B go along for the ride so I add a level to the sort so the final sort is by column A, then column B. Is that the way I'm suppose to be sorting?