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
Bookmarks