This can be done by creating a "button" on one worksheet and creating the top ten list on a second worksheet. Then, add a filter action that runs from the button worksheet to the top 10, making sure to Run the action on Select and choosing to Exclude all values when clearing the selection. The following link should provide some more insights:
Hope this helps!
Thanks a lot. i will follow the steps to implement this.
When creating a filter-action button, it will "select" or highlight on the original worksheet before sending the user to the next location. Is there a way to prevent the highlighting?
(I have used this method for creating buttons such as 'Home'. When you return to the page, the button will be highlighted and has to be deselected and re-selected to fire again.)
Thanks, I'll take a look. I just found the following article which mentions a way to deal with removing the black border.