I need help with a macro to do the following:

Cell B2 = 12/31/2015
Look in Range A1:A100 for this value (B2)
If found, overwrite (or do nothing)
If not found, paste value in last empty cell in range

Thanks!