VBA and filtering table

I need help with my macro. I am not too familiar with tables.
First the user will filter "Application" by name. Then the user will run the macro (ctrl+m) from there.

The macro will:

1. Sort Sub-Category in ascending order
2. set the range to sub-category, but applies only to post-filtered data (we don't want it to include all the pre-filtered data)
3. Generate html tags

1. If the sub-category name is mentioned only once, display the name as "[SUB-CATEGORY]"
2. Otherwise display the name as "[MANUFACTURER]" when there is multiple occurances of sub-category names

I know I'm doing it wrong but I don't know much about tables.