I have run a Lottery Syndicate since the very first draw (Saturday draw only).
Because of the amount of tickets we have (35) I have written a lottery checker in Excel.
I also have another worksheet with a record of all the drawn numbers, again Saturday only, which is now down to row 546. On the same worksheet (49 rows) is a formula which calculates the frequency that each number has been drawn.
At the moment those 49 rows are static and every week I enter the latest drawn numbers (today will be row 547) but to see the effect of the frequency check I have to hit Ctrl + Home to get back to the top of the worksheet. What I would like is for those 49 rows to follow me down the worksheet as I scroll. Does that make sense? If so can it be done?
VoG™, yes I can scroll in both windows. But I am sure I have seen an Excel spreadsheet where a particular portion (as a block) of the sheet follows down whenever scrolling. I must say that I am happy with the split screen as you suggested.