How can I automate data validation on a new sheet according to my categories?

[Suzanne]

How can I create a category column in a new sheet tab with data validation that functions like the category column on the Transactions sheet? That is, specifically, data validation that updates automatically when I update my categories rather than having to manually enter each category.

Thanks in advance for the help. I’ve studied the sheet itself and spent some time on Google, but can’t figure this one out.

[Mark.S]

Select one of cells that has the data validation you want to copy and then select
Menu > Data > Data Validation

Then with this information for a model, go to the new sheet add the data validation you want.

Here is what mine looks like for reference: