I have a basic excel football spreadsheet that calculates total points in one column, i have set up a macro to put the team with the most points to top autmatically everytime i enter a value. I can get the macro to work on 1 sheet just as i want it and one sheet only, the problem is when i try to introduce other sheets, I have four sheets for premier league, championship, league 1 and league 2 how can i set up a macro to work on 4 sheets, or can i set up 4 macros to run on the same file? i guess for me that would be easier since im no excel expert? any help would be really really appreciated.
Paul