Forum Discussion
Click a cell value into another cell
I built a "Grower's Log" to keep track of germination and harvest times for plants based on when their seeds were planted. On the first page is the seasonal log, designed to be cleared out at the end...
There's two tables, the log and the database. The log is just a log that keeps germination and grow times, the notes can be added and amended in the database table at any time, it doesn't get cleared out. No notes are added in the log. What I'm trying to do is make the list work in reverse, so that I can click a plant into the log from the database table, rather than selecting it from the list in the log table, so that if I'm going through the database and decide I want to plant something, I can just click on it and it will send me to the log and and place the item in the first open row. Can you help with that?
You can instead create a searchable drop down list in each of the cell to your Log where when you type the name of the plant the drop down list will filter to the specific plant (much like autocomplete)
Cheers
Cheers