Years ago I created a database of my boss's clients. I always add a new client when we open a new file. It seems that in the last several days, any new clients I enter are saved out of sequence. I need to give you some specifics to explain this, I think.
I use columns A through Q to enter a client's info on a line: type of case, client number, name, address, etc. After entering a new client's information, I click/ select the name cell, then go to the top of the page and click the sort/ascending icon in the Sort & Filter box. This has always (for 12 years) sorted the names alphabetically and sorted each client's information (meaning that entire particular row) along with the client's name. Now I have 4 new clients, 1 starting with "L" and 3 starting with "S", saved in between 2 "Toellners" (?). On top of that, all the entries above the 4 new clients are correct, but the 4 new clients and all the entries below (T through Z) are only correct until column K. After that, the correct info appears 4 rows above the line with that client's name. Please note that I always enter a new client at the end of the list and then sort by the name after all info is entered. From what I have read in my search for an answer, I understand that part of the problem could be that columns H through K are often empty. Still, why would this be affecting the process now when it didn't before? Also, it doesn't explain why the 4 new names are saved out of alphabetical sequence.
I have no idea how or why this occurred, and even less idea as to how to fix it. I know very little Excel - I learned what I know from using the help menu - so forgive my ignorance if this should be obvious. I would so appreciate any input/suggestions. Thanks.