I have a spreadsheet that feeds info into two other sheets within the same worlbook and I would like these other two tables to automaticaly sort when I change the info in the first. At the moment I have set up a macro to sort the relevant info manually, but it would be better if it sorted when the main page is changed.
Any ideas?
Any ideas?