Scenario:

I have a sheet called certificate,now when i type the name of the person in the sheet1 then automatically the name of the person will display to cell in a sheet2..
any idea?

Thanks!

Good day!

Godbless Us!