I want to create a data validity list for a Calc cell that fetches it’s data from a Base table.
Is this possible? If so, how?
TIA,
Register the database so it appears in the data source window.
Create a query returning the relevant values.
Drag the query from the data source window into your Calc document.
Call menu:Data>Define… and notice the name of the linked database range (might be like “Import1”).
menu:Data>Refresh refreshes this range.
menu:Data>Validity…
Allow: Cell Range
Souce: Import1
2 Likes