Have Data Scroll within a Spreadsheet

Hi,

I have a spreadsheet which has anywhere between 100 and 300 lines of data.

each line is a transport delivery

the data is contained in columns B through G down the pafe

the data (deliveries) are then manually copied into groups call 'Runs'

the runs are in columns I through to CJ

(this will all make sense with the attachment open)

the width of the spreadsheet is not a concern as all users either have a multi monitor set up or widescreen displays, however scrolling up and down is a real pain

I would really like the delivery data in in B through G to scroll without effecting the 'Run' templates to the right of it, as they require scroll horizontally as well.

I can't seem to get it functioning use the split function or freeze panes function

Does anyone understand what I'm requesting and can assist?

Thanks in advance

Thanks Avk,

I either don't understand what you mean, but it is important to know the data does not contain the run number.

A human looks at all the data and manually copies each delivery into the desired position.

I have uploaded a more detailed spreadsheet to the which shows the final product