Dragon Blood

Glad it helped, thanks for the post back!

Mike Rogers

"Dragon Blood" wrote:

Thank you all for your help. That has saved me hours of being stressed.
Again thanks.


"Dragon Blood" wrote:

Hi. I am currrently in the Royal Navy an with all its spending power we are
still running Excel 2000. What I am trying to do is, I want to keep rows 1
& 2 stationary when i scroll down. This is due to the fact that I have a lot
of customers in column A. I also have a list of stock going fom A to FE.
So when I scroll down to find a customerr in row 312 for example. I need to
know what column the entry is to be inputed into instead of press ing pge up
all the time.

E.G.

Rows 3 - 300 are customer names
Columns A -FE are different stock

In rows 1 and 2 I have stock information. When I have to input data for
customer on row 200. i have to page up to see what product i am on. How do
I get rows 1 & 2 to stay staionary when I scroll down.

Your help in this matter will be most appreciated.

Dragon Blood