Forum Discussion
Click a cell value into another cell
I was hoping I could use a formula in the PlantsList, somehow use HYPERLINK with MATCH to send me to the first empty cell in the log, and then IF statements: IF [@PLANTED]="",[@PLANTED]=[@PLANTS], something like that?? I've yet to make it work
A hyperlink will just jump to a specified location, it won't fill in the destination cell without vba (and while you can hyperlink to a variable cell location using the hyperlink function, it doesn't trigger the necessary event to activate the vba code I think you would need).
If simply linking the cell or copy/pasting aren't suitable, then I don't see how you accomplish this without vba. If you look at the attached workbook, it should fill in the log when you double click on the plant name from the list. If you right click on the worksheet tab and select view code, then you will see the macro code. You should be able to modify the "Set" statements for your worksheet/table/field names.