S
sunilpatel
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
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