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-13 Oct-13
Dept. # Description E S T TOTAL E S T TOTAL
21290 Contract 1 0 0 1 1 0 0 1
21400 Trim 0 0 0 0 4 0 0 4
21401 Mini-Shift Inventory Control 6 1 2 9 6 1 4 11