Multiple Tables Scrolling Together

[#1]

Is it possible to have multiple straight tables with the same number of records to scroll in unison?

For instance, if I set up two tables with the following data:

OrderNumber, CustomerName

OrderNumber, Order Quantity

I want the bottom table to scroll with the top table when I scroll to a particular set of order numbers. Mainly, the reason for this is that I have more data than I can fit into one table so I have to make many within one sheet. Also, as I scroll through the top list of item numbers I want the bottom list to scroll through as well (before filtering). Please note that both tables will have the same OrderNumbers and will be sorted in the same order.

Any suggestions? Is this possible?

[#2]

Dear ,

What immediate strike in my mind is use of "Slider " .

You can have slider bar with variable and assign same variable to your tables .You can rank your records/ rows & assign varibale to those.

let me know wheather it wrks or nt.

Cheers,

Bhushan N

[#3]

I appreciate the quick response... Unfortunately, the slider does not seem like a convenient way for me to scroll through my data. In my particular case I have many more item numbers than the slider bar will display. As a result, the slider makes it difficult to scroll through all records.

Mainly, my problem stems from the fact that the straight table I wish to create always runs out of memory as I add too many columns. I am trying to replicate a query I run in access, but it does not seem to fit within the memory of the object. Hence, my solution was to make many tables on the same page, but ran into the problem of them not being in sync with each other.

Ideally, I would like to allow the object to have enough memory to display all the information I need so I can quickly export to excel.

[#4]

I have exactly the same problem - unfortunately haven't found a solution yet!

[#5]

I eventually just did all my aggregation and formulas in the script and the table was able to fit as I just pulled the fields to the table. As for the multiple tables scrolling together, I now think it is just easier to group data into buckets and just filter as needed.