TECHNOSQUID
New Member
- Joined
- Sep 3, 2009
- Messages
- 3
I am created a forecasting tool. I would like to use scroll bars to calculate a projected amount based on a prior years actuals. Each month will have a scroll bar for each line item. Scroll up to increase a projection, scroll down to decrease not really rocket science. But, when I create an initial scroll bar then copy and paste it to where I would like it to be positioned, the Link Cell is stays the same. Is there a more efficient way to move the Link Cell besides going into each scroll bar's format control? I could easily have 120 scroll bars.