Creating Tabs based on criteria VBA

[Klc1992]

Hi! I’m very new to writing VBA and really struggling. I am basically trying to create a template where a user can drop in exported raw data and it sorts.
I made a master sheet of all the statements that categorizes them by Tab and subcategory and have that as a vlookup to the data
So as an example it will look like
Income, percent of population, index, demographics (this is the tab vlookup), employment (subcategory vlookup)

So I want it to automatically drop this data in the demographics tab and have separate sections based on subcategory. Would love to highlight based on criteria as well

I hope I’m explaining this well, I’ve been driving myself crazy because I feel like it shouldn’t be this hard.

 

[Klc1992]

Hi! I’m very new to writing VBA and really struggling. I am basically trying to create a template where a user can drop in exported raw data and it sorts.
I made a master sheet of all the statements that categorizes them by Tab and subcategory and have that as a vlookup to the data
So as an example it will look like
Income, percent of population, index, demographics (this is the tab vlookup), employment (subcategory vlookup)

So I want it to automatically drop this data in the demographics tab and have separate sections based on subcategory. Would love to highlight based on criteria as well

I hope I’m explaining this well, I’ve been driving myself crazy because I feel like it shouldn’t be this hard.

Oh also there are certain subcategories that need to be sorted based on index (high to low)
Appreciate any help on this!!! Thank you