I'm working with a scroll bar and cell link setup in conjunction with an offset in a formula.
And I have a sheet with columns of dates that will change when adjusting the scroll the bar, and those dates/months run lowest to highest. ie January in Column A, December in Column L
It all works as 'expected' that when moving the scroll the bar, the dates will update based on the linked cell and the offset (have 36 months, and showing 12 via a scroll bar)
But the problem is, the scroll bar is 'backwards'. When the scroll bar thumb is on the far left, the linked cell will be 0. But I want that to on the far right side if possible? Essentially flip the scroll bar 180 degrees.
Can that be done or do i need to rethink the data and offsets?
Bookmarks