I need to create a file where there is 1 master worksheet and based on a system (it can be 1 column with a number put in 1,2,3,4,5,6,7,8,9 etc.. it will then take all the data of that row and populate a different worksheet in the same file ( so all the data gets entered into the master worksheet and then gets split up into the appropriate other sheets based in the number put into one of the columns in the master. I would need 1 master and 12 to 15 break outs for the sheet. can use numbers or letters or whatever to categorize the sheet.
This will be a growing sheet worksheet so it needs to be able to keep sorting the data to separate sheets as i add rows.
I will also need the ability to sort any of the sheets based on the columns there. and add new columns to the master (the column names will be the same on all the sheets..it is just an auto sorting feature to break up the master into the others..
There might be a 2nd filter based on Text color.. the idea is the master might belong to 2 people (or more in the future) so all of the Green colored text with "1" go to worksheet A , blue colored text with "1" go to worksheet B..
I can help create a skeleton if needed but I wanted to see if this can be flexible first.