Numbers: Drop down list with varying value
I stepping over from Excel to Numbers and I’m looking for a way to create a drop down list where values are based on a range of values on a separate tab/sheet. For example: column A on a tab contains some values. Now a want to link a cel to that column in that way so I can choose a value (from previous said column A). And if I add or delete a value in column A, the new set of values or shown on that linked cel to choose from. Like Excel can. I hope I can do that in numbers too. Anyone tips on that? Would appreciate it. Thanks
MacBook Pro 15″, macOS 14.4