I have a spreadsheet with about 70 columns. Picture names across the top row, and jobs, and job information in the first 5 columns. The number of hours associated with a name and a job in the middle. the page is split right after the job information. By clicking on a cell with a name, the whole page is sorted by hours. The problem is that when sorting by a name, I'd like that column to scroll left so that it is adjacent to the split. Any ideas?
Trying to make a column scroll up against a split
-
-
-
Re: Trying to make a column scroll up against a split
Hi Zzzt
Welcome to ozgrid
Could you upload a small relative example?
-
Re: Trying to make a column scroll up against a split
HI
If you can identify the column number that contains the name (presumably you can as you are sorting by it) then try something like
where ?? is the relevant number. This should put the column next to the split.Tony
-
Re: Trying to make a column scroll up against a split
ActiveWindow.ScrollColumn worked! Thanks!