+ Reply to Thread
Results 1 to 2 of 2

Auto sort

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    madison, wi
    MS-Off Ver
    Excel 2010
    Posts
    2

    Auto sort

    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.
    Attached Files Attached Files

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Auto sort

    Hi bfbirch

    Welcome to the Forum!

    First, we'll focus on this
    I would also love to have a form in which I just enter the data and then it puts it into my spreadsheet
    It's relatively simple but gets a bit complicated, depending on how you use it.

    Couple of questions:
    • What's the significance of the "MRN" number and how is it assigned...these will be out of sequence once you've sorted the data by last name.
    • Do you have a list of "GENOTYPE" s?
    • Do you have a list of "STAGE" s?
    • Is "TX NA¤VE Y/N" always a Y/N answer or can it be blank?
    • I assume "TX COMMENTS" is truly a comment...or is it restricted to specific comments...if so, a list please.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1