Hi Tiny4725,

welcome to forum.

See the attached file and run the macro using button.... let me know if this helps. thanks.
Search and display column.xlsm

regards,
DILIPandey

<click on below 'star' if this helps>