Putting mutliple scroll bars in the middle of the sheet.

[Volos]

I'm working on a COM add in, but I would be happy to have this solved in VB or VBA. I have user reports that are generated based off selections from a database, then the sheet is added into an existing sheet. I've been told I need to keep the same basic format and leave it in Excel. The problem is that these lists within the form could be of a much longer length than there is space for.

Here is what the current form looks like:



My thought on a solution was to drop the total to the theoretical end of the Worksheet (these are the bottom of the form), and then have the middle scroll with a scroll bar.

Is there a way to have 3 separate scroll bars that only scrolls each table (again there is stuff above these that wouldn't scroll)? I've only seen scroll bars that scroll the whole sheet.

Is there a better approach?

[Volos]

I've thought of trying to use the Index function, but I would want the end user to be able and edit the information as they scroll (and an index would be written over in this case).

[westconn1]

in excel you could use split (multiple) windows side by side
this could be automated from VB