Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Sort Table By Top 20


I have in  worksheet  RW  data, and i want create cross table another work with Top 20 team medal list rows.I have attached sample. and it has to change by year drop down list, including slier?

Year Sport Gender Event Athlete Age Result Medal City Country Team Season Team Medals


Hi VisaF1 and welcome to the Forum.

You said "I have attached sample..." but there is no sample file in your question. Please edit your original question and use the Add Files... button to upload a representative Excel file (without any personal data) to show your existing data. Only Excel files are permitted.

You seem to be asking us to create a solution for you but please note that we normally expect you to show that you have made an effort to fix your problem.

Also what you mean by "slier"?

Pl,ease respond to all points. After that, we should be able to give specific help.
John_Ru (rep: 6212) May 20, '24 at 3:49 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login