Populate comment based on info in another excel

[ladydubs]

I am working in one workbook with two sheets.
Sheet One: Ticket Sales
Column A: Ticket Number
Column B: Ticket Holder Name

Other columns not relevant for the question.

Sheet Two: Projector Slide
Column A: Ticket Number

What I need to happen :

Sheet Two will be displayed on a projector during a drawing. As the number of each ticket is announced they mouse over the cell of the ticket number and the comment box appears with the name of the person that had that ticket. This event has been going on for years and each year this has to be done by manual entry of the names into the comment box. Is there a code to be able to automatically populate the names into a comment box in sheet 2 when they are entered into sheet 1?

Thanks in advance

 

[Jaafar Tribak]

I am working in one workbook with two sheets.
Sheet One: Ticket Sales
Column A: Ticket Number
Column B: Ticket Holder Name

Other columns not relevant for the question.

Sheet Two: Projector Slide
Column A: Ticket Number

What I need to happen :

Sheet Two will be displayed on a projector during a drawing. As the number of each ticket is announced they mouse over the cell of the ticket number and the comment box appears with the name of the person that had that ticket. This event has been going on for years and each year this has to be done by manual entry of the names into the comment box. Is there a code to be able to automatically populate the names into a comment box in sheet 2 when they are entered into sheet 1?

Thanks in advance

This can be accomplished via code.

What is the exact address of the ranges holding the tickets and ticket holders in both sheets ?