Need to Have Form Control Scroll Bar, scroll left to right

ctiger

New member
Joined
Nov 4, 2013
Messages
16
Reaction score
0
Points
0
Excel Version(s)
2013
Hello All,
I have set up an excel dashboard for staffing. I inserted a form control scroll bar and need it to scroll left to right to view previous months but I can get it to only scroll up and down. My formula to gather my data is: =OFFSET('Staffing Data'!B3,Financials!$R$40,,) with R40 being the linked cell to the scroll bar. How can I change the scroll bar to go from left to right to read previous months?
Nov-13Oct-13
Dept. #DescriptionESTTOTALESTTOTAL
21290Contract10011001
21400Trim00004004
21401Mini-Shift Inventory Control612961411
 
Top