I have information on sheets with dates next to it. This indicates the last
time that a vehicle was mot'd. Is there anyway of these dates automatically
being placed into a calender??

I.e. the date is in a1 and for example the information (vehicle
registration) is next to it in a2. Ideally, i'd like a calender that can pick
up which wagon was mot'd and place its registration number into the calender
on the relevant date..

any help would be greatly appreciated

Cheers