VBA Constant Multiple Sorting
Hello everyone, First time posting so apologies in advance
I have spreadsheet with 6 football group tables, I have columns which i want to sort each table in a particular order (Points, Head-to-Head, Goal Difference, Goals For, Fewest Goals Against), this is simple enough with a Macro however I just cant get my head round how to automate this, either constantly or when a change is made to the workbook
Any help would be greatly appreciated
Euro 2016.xlsx
anyone please?
You could probably use a Worksheet Change event handler. However, I think it could be disconcerting if, when you put data into a cell, that cell suddenly moves up or down the worksheet
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks