Data input form referencing to table/cell titles (excel 2010)
I'm creating a small calendar in Excel and i was wondering whats the best way to input data in to my table.
So far my ideas to have a data input form where i select a name and enter my custom date with my custom text. My logic behind this on my form i select "Tom" from a a drop down, and then i insert the date "16/02/2012" and in my custom text box i would enter in something like SF which should populate cell E6 with SF. (see example below)
I've got very basic VBA skills which i did in collage way back but i don't putting some effort in to learning. :)