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

Posted on Apr 22, 2024 1:21 PM

Reply
2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers: Drop down list with varying value

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.