Auto sorting , auto update and auto save

Hello,

I am working on a workbook to track overtime with personnel. It is based off of seniority as the worker and how much overtime you have worked. Attached is the workbook. What I am looking for is a way to sort 3 set of cells (rows 3-54, rows 42-45, rows 47-54) , each on 2 levels (first sorted by column C smallest to largest ,then column A largest to smallest). Column C is updated every time a number is put in throughout the workbook on the same row using the SUM function. What I want is the workbook to auto sort everything and save every time an entry is made in the workbook. Sheet1 is what it originally looks like and Sheet2 is what I want it to look like when everything works. Can any one help with this problem?

Hi there,

Take a look at the attached workbook and see if it does what you need.

Changing the value / inserting a value in any of the cells in the Range(D3:No54), but excluding those columns which contain Officer Names, will cause the worksheet to be sorted in the way which you have specified.

The workbook uses the following code inserted into the VBA CodeModule of the worksheet which contains the data to be sorted (Sheet1):

Please Login or Register  to view this content.

The highlighted values may be altered if the layout of your worksheet is ever changed.


Hope this helps - please let me know how you get on.

Regards,

Greg M

It worked great, thank you.

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated

You're very welcome - I'm pleased that I was able to help.

Best regards,

Greg M