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.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.