# SpinnerTool

• I am trying to create a spinner tool so that it increases / decreases a number in cell A1 and then at the same time increases / decreases a number in cell B2

For example

A1 = 1

B2 = 3

Press Up

A1 now =2

B2 now = 2

Press Down

A1 = 0

B2 = 4

Is this possible?

• Hello,

Attached is your test file

Hope this will help

## Files

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• Is there a way to make this work say for example if A1 = 60 and B2 = 90

• You are welcome ...

## Files

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• As Carim demonstrated, you just need to link the spinner to one of the cells and use a formula in the other cell (eg B2 =150-A1).

Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!