Forum Discussion
Click a cell value into another cell
One option could be to link the growers log to the plant list. Type "=" and then navigate to the plant list and select the item you want to add.
Another option could be to copy/paste special value the item from the plant list to the grower's log. If you don't want to copy one at a time, you could add a "Select" column to your plant list with an indicator (let's say an "x") as a data validation dropdown list. Then, make your selection by entering "x" in the new select column, filter your list for your selections, then copy/paste special value over to the growers log.
Edit: Edited to remove my formula suggestion. Since the date in the growers log is hardcoded, using a formula to pick out the selected items in the plant list would cause the date to not match as you add plants to the list (the formula would re-order the list). Sans vba, the only think I can offer at the moment would be to either link the cells, or copy/paste special value from the plant list to the log.