Well like the title suggests i need to link a spinner to two cells.

I've set up the spinner to link to cell B8 but i also need it to link to O18. B8 will always remain at a certain value that the user puts in but O18 will reset back to 0 each time and register an increase in in B8. I figured that being able to link the spinner to the two cells would be able to do this. If not is there another way?

and also since adding a spinner to B8 my validation rule no longer works. It used to alert the user when the number in the cell dropped below the figure in B9 but now it does not work. Anyway around this?

I will include a screen shot of the spreadsheet.

Hope someone understands!

thanks, lizi

http://pic16.picturetrail.com/VOL692.../288562138.jpg