I would like to extract data from my main sheet to different sheets depending on criteria in one row.
The criteria can be different from one word to multiple words.
The main sheet will be pasted data weekly so it shouldn’t be depending on a specific row count.
The copying should be made from the main sheet to the different sheet (up to around 8 sheets).
How would this be easiest to make? VBA or Formulas?
Im thankful for all the help I can get.