Macro to refresh a leaderboard

Hey guys.
I am creating a leaderboard with votes 3, 2, 1 and i want my leaderboard to refresh with a macro.
I have self taught my way with this conversation,
http://www.excelforum.com/excel-work...aderboard.html
and i need some help just to finish off the job!

The macro is included in the final attachment provided in the link you supplied. It is tied to the object at the top of the Leaderboard tab. Copy/paste from the VBA editor and paste into a new module in your spreadsheet. You can then associate the macro with a button or object as the other guy did.

thank you very much. I achieved what i wanted to do!!! I am soo stoked!! THANKS