Hello, i`m a designer and producer of small furniture and i am trying to create a tool, in Numbers, to easily make offers.
I have some sheets that i would like to use as databases :
Name; Type; Length ; Width; Thickness ; Price / Square meter; Price / Sheet
So basically i want to create a sheet in which i would like to add(type) in a list, materials and services, (preferably having the type suggest function from my materials and services databases).
After adding all the informations i would like to have a nice list with all the needs, and a total value calculated from items in my databases.
I saw some videos that you already made but they don’t actually solve my need. Having a pop-up Menu with items from my databases is not so efficient because the list of materials is long and i lose time scrolling to reach the needed material.
I want to add that i am willing to share the tool in the end, being very useful !