I’m a beginner in terms of using the automation feature for Excel. Now I have used the automate record feature to create PivotTables for a report. However, in the script it didn’t sort the data from largest to smallest, which is my first problem. My second, is once I sort it manually, I would like to have an automation feature that would take the top 10 from 2 general categories in each PivotTable and insert them into tables on different sheets. However, sometimes these categories don’t always have 10 values. Is it possible to limit the number of cells it copies and pastes to the tables?
enter image description here
enter image description here

I have an idea of what I could possibly do, but don’t know if the features are available. My first guess would be to take the Category Con & SM and filter values from largest to smallest while taking the first 10 available rows in each subset to filter into the tables, but anytime I try something it takes the blank category which is beneath the two items in the SM category.

enter image description here