Excel 2007 Auto sorting rows by multiple columns that contain values that are calculated

Hi all

I'm trying to insert auto sort functionality into a spreadsheet at work and I am struggling a bit. I've found a few examples around here and on the web that are slightly like what I need, but not exactly.

The data in my spreadsheet is confidential so I've had to come up with something similar and have used the Premier League table. I've created this in Excel 2013 but my work computers are running 2007.

In theory what I would like to do is sort the data automatically as it is entered, First by column H (highest to lowest), then by F (highest to lowest) and then by G (lowest to highest).

Column H can be updated by a change in column C or D.

For example if I changed cell D20 to 6, H20 would become 33 and I would like the entire row 20 to switch with row 19.

From looking around it looks to be a case of adding VBA code but I can't quite work out a solution.

Any help, even pointing to a thread where this has been previously answered, would be greatly appreciated.

Thanks

Right click on the Sheet tab, click view code and paste this code in the VBA window that opens.

Please Login or Register  to view this content.

No problem at all. You can just extend the intersect range line like so:

If Not Intersect(Target, Range("C2:D" & lr, "F2:G" & lr)) Is Nothing Then


Code update:

Please Login or Register  to view this content.