I have a table in excel that has names and other data. I would like excel to automatically sort it by last name, which is the second column, after I enter a complete row of information. FYI, I am not familiar with much more than the basics of excel, I have never used macro or anything like that so please explain it step by step.
Secondly, I would also love to have a form in which I just enter the data and then it puts it into my spreadsheet. Is that pretty simple? Would I need to use Access for that. I have never used Access before.
I have attached a similar spreadsheet. I removed private information and made it more plain.
Bookmarks