Excel Macro Coding, Excel VBA

ello All,

I have one excel sheet and I want to make one search pop up box for this sheet, whenever i enter any mobile number in the sheet, that column should show and get highlighted green color automatically.

Also you can make like this way. You can create one new sheet and that link with this excel sheet, And there will be one pop up serach box on that sheet, when i search any number from database file, that row fetch to new sheet

Thanks