Auto Sort Data As Information Is Entered

Hi folks,

Looking for some guidance with regards to automatically sorting data in columns as information is entered.

BACKGROUND:

I work at a small airport and am responsible for managing slot times on 3 different aprons. The way of doing this in the past is pretty archaic, so I am creating a spreadsheet for the users with drop-down menus to simplify.

In each row:
The user can select either II, IX, or X from column B.
In column C the user selects a slot time.
In columns D-H, some more information is entered.

What do I want?

As information is entered into columns B & C, I would like the columns (and all subsequent data in the same row) to sort.

First to sort ascending based on the data in column B, then sort ascending based on data entered in column C.

Working example attached.

This is my first post, so I apologize if I'm unclear. Please let me know if I can provide clarity.

Thanks in advance for your assistance!

I only see an image.
Please post a workbook.

ViewPic

Try such code inserted in your Sheet1 module (right-click on Sheet1 tab and select Display Code to see/edit it).
Macros have to be enabled.

Please Login or Register  to view this content.

Well if I had know someone else was going to help you I wouldn't have bothered writing this code.
But here it is anyway.

Please Login or Register  to view this content.