Hello!
Is it possible to view data in multiple columns running down a spreadsheet tab, in multiple windows side by side? I'm creating dynamic calculation "forms" that cost out a project with multiple parts, and need up to 20 parts on a spreadsheet tab. I currently have these forms running down the spreadsheet so that all viewable data is in columns A-H. I then need to view the costs of the first "part" against the other 19, hopefully side by side. I was hoping to just be able to programatically split the spreadsheet so that the left window would be frozen on the first instance, and then all of the others could scroll down the right window. Unfortunately the split only provides one vertical scroll bar, so both windows scroll together instead of separately.
Any suggestions would be greatly appreciated!
Thanks!
Is it possible to view data in multiple columns running down a spreadsheet tab, in multiple windows side by side? I'm creating dynamic calculation "forms" that cost out a project with multiple parts, and need up to 20 parts on a spreadsheet tab. I currently have these forms running down the spreadsheet so that all viewable data is in columns A-H. I then need to view the costs of the first "part" against the other 19, hopefully side by side. I was hoping to just be able to programatically split the spreadsheet so that the left window would be frozen on the first instance, and then all of the others could scroll down the right window. Unfortunately the split only provides one vertical scroll bar, so both windows scroll together instead of separately.
Any suggestions would be greatly appreciated!
Thanks!