advanced excel courses - Two or more work sheets

Hi Darren

Thank you for your question

When you say split worksheets do you mean split panes?

If so then a split pane simply allows you to break the window into up to 4 different views, each showing a different section of a worksheet. To do this click on Window-Split, and then go to the required ranges in each window.

As to the second part of your question could you please clarify your requirements, so I can be more specific in my answer

Regards

Stephen