Are your lists on the same sheet or different sheets? Do you ever add new
items to your master list? Is there a chance of duplicate values?

Your solution will require some VBA code. I suggest you start trying the
Find Method to match the values you are trying to compare, then use this to
determine the row containing the right date and then setting the target cell
value equal to the value you are looking for.

If you need some help withthe VBA, let me know.
--
HTH

JonR


"Tom D" wrote:

I have a master list of items that contain a date, time, and description, on
one sheet. I have 6 sub lists. I want to be able to match between the
list and the sublist and then put the date from the master list on the sub
list. How is this done?