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?