tab or scroll though column set

[TightLikeThat]

column a and b are frozen.
I want to create a tab to scroll each distributor (cutting edge, vanguard and more to be added) with the 4 columns to be seen with the frozen columns. instead of sliding using slide bar.

[pjwhitfield]

Sorry, are you saying that you want it so when the user presses tab key it wont go from column to column but technically, jump 4 columns taking it into the 1st column of each distributor? ie the cursor is in C3 and if I press Tab it will jump to G3 instead of the usual D3?

Its easily done with a button, create a button somewhere in your frozen area and give it the following line of code:

Please Login or Register  to view this content.

[TightLikeThat]

yes thank you. I tried. i've attached the file to see if you can fix it.Wine Compilation.xlsx