Hello All,

New to the forum and couldn't find an answer to this question, if someone could help me out it would be greatly appreciated.

Is there a way to autopopulate cells with a drop down box? I would like to have a drop down box where if I select one value in that box (say "fruit") it would automatically display "fruit" in cell A1. Then when I use the SAME drop down box I select something else (say "meat") it would automatically display in "meat" in the next row under "fruit" in cell A2.

Is this possible? I've tried fussing around with macros, and VBA a little bit, but I don't know nearly enough about either to make this happen. I would even be okay with using a simpler method like INDEX(MATCH()) or a LOOKUP function if that would work.

Any help would be great and much appreciated... Thanks!!!