hi from a newbie

in column A i have a very long list of medical products in alphabetical
order.
I keep having to scroll up and down all day to find items. I would like a
sheet macro to detect a cell change e.g in B1 i enter "para" and column A
scrolls down until "Paracetamol" is visible on the screen in column A. (i.e
column A automatically scroll to line 400 where cell A400 is Paracetamol).

Thanks in advance

Sunil