Search and display box.

Hi,

I've been having a look around Google and here and have gotten nowhere fast and become a bit frustrated!

Basically I'm trying to create a button on sheet2 that opens up, prompts for the CHI number from column A and returns the entire row for that matching number back on sheet2 again. The idea is so that the user wouldn't have to touch sheet1 or even know it's there. Only click a find patient button on sheet2 and be presented with the results.

New to macros, VBA etc.

I've attached a mockup workbook with fake names and numbers etc for you to see what I'm on about. The real version I will be using is laid out exactly the same only with lots more rows. It will also be constantly added to.

https://www.wetransfer.com/downloads...4131917/9cd922

Sorry for the file sharing link! I can't upload stuff directly from the work network. It wont let me : (

I'm not entirely sure that this is possible and how to go about it!

Thanks in advance for any advice or help!