Scrollable area

[Amnesia_180]

Hi there,

I have been searching through some topics on this board and have not found an answer to my question yet.

Here is an example of what I am trying to do.

Cells A1 - A6 are occupied... so are B1-B6, C1-C6 etc

Now, A7-A14, B7-B14 etc Have lots of information, so I want these 7 cells to be scrollable, for say 100 cells. So instead of having A7-A14 you have A7-A107 but only see A7-A14 unless you scroll down. Then att the bottom of all that you have the total, in what would be A108 but it shows just below A14.

I believe this is similar to Freeze window formula?

Do you know what I mean?
I hope you can help

Thanks
Amnesia

 

[Purple Youko]

You can "split" the window but I'm not sure that would do what you want.

 

[Amnesia_180]

Hi,
In order for this to work I would need to split the area/window in 2 places. Is this possible?

 

[Amnesia_180]

*bump*