Copying a New inputted Date into another Cell

[InternSeekingHelp]

Is it possible to include a new date inputted in Column M and Copy it a Specific Cell Automatically?
Same goes for the Future Dates like the Yellow one.

I don't think the IndexMatch function will help me with this.

 

[AliGW]

Try this in O6, dragged down:

=INDEX($L$2:$L$100,MATCH(0,INDEX(COUNTIF($O$6:O6,$L$2:$L$100),0,0),0))

 

[InternSeekingHelp]

Then how do i use the CommandButton in VBA to automatically lead me to another Different Sheet to show a Specific Cell/Range. EG: X 675

 

[InternSeekingHelp]

Try this in O6, dragged down:

=INDEX($L$2:$L$100,MATCH(0,INDEX(COUNTIF($O$6:O6,$L$2:$L$100),0,0),0))

What does your Formula do? I am quite Confuse trying to figure out what that $L2:$L100 does.