Need help with auto sorting in Excel

Question

I need Excel to auto sort smallest to largest descending and pull other cells to the new location as a new time is entered.

In detail:

Column C is time of day for a specific event (in military time) beginning on Row 5.  When a user enters a new event and assigns a time to it, I need that corresponding information to sort into the correct event row.  Below is a capture of the worksheet.

So for instance; The data entered for Event #10 beginning with Cell C14 and ending with Cell I14 would need to move to the row for Event #1 (Cells C5 to I5).  So basically I just need Columns "C" through "I" beginning on row 5 to auto sort based off of the time entered in column C so that the proper Event # is met based off of the time of day that it occurs.  I believe this requires a Macro but I am unfamiliar with those.

Answer 1

I cannot replicate the problem and had no problems when testing the code before posting it.

I have just finished testing again on a new workbook and cannot raise an error.

Do you have other book's sheet event code that may be conflicting?

Do you want to post the workbook to a file-sharing site?

Gord

Answer 2

Gord,

I tested it on a new(blank) workbook and it yielded the same error.  Again, I am using Excel 2k10.  Do you think the issue may involve the file type that the file is saved as?  It is currently a .xlsm document and the Trust Center settings for Macros are set to, "Enable all Macros" and "Trust access to the VBA project object model".  Not sure what I am missing here.

Answer 3

And yes, I would be glad to upload the file to a sharing website to see if we can resolve the issue.

Answer 4

When you get the file uploaded to a site, post the URL.

Gord

Answer 5

https://drive.google.com/file/d/0B6XlG46lvuYcSVZTR3dlRWctcnc/view?usp=sharing