split window stop scroll in bottom ?
 

hi

I have a work sheet split in half
the bottom half is used to keep a list of replacement
caretakers who cover for ones on holiday,
the top has the assigments
ie
jim covers for ted at theis site


how can I make it so the top and bottom
cant scroll in the same space

ie top scrolls from row 1-500
bottom scrolls row 500-1000