I have data where an end user put's scores in & this is linked to a workbook
called Team # 1 scores. This updates a sheet "Team Scores Weekly which
updates another sheet in the same workbook "High Game Scores". I created a
macro to copy & sort the High Game Scores from High to Low which works fine
when I click the button. I want this automatically sort as Scores are
entered each week by end user. I changed the macro to a Function. After
reading other questions made a new macro & used the function & macro together
got a value error & excel encounterd a problem & kicked me out. I know its
me. I read about Workbook_open etc from all the other questions. I'm new so
?? Please help.