I'm trying to create a new sheet on google sheets whenever column B gets a new value. This sheet will be named the value that created it. . I also want to have a function in the new sheet that contains the value that created the new sheet.
For example, if B3 gets the value "John Doe", a new sheet will be created titles "John Doe" and A1 of that sheet will be the filter function with "John Doe" as the filter.
I tried using macros but they are way over my head. I figured out how to create a new sheet in a script but from there I'm stumped.