Spin Buttons - Linked Cell to update when copied?

[svpdebbie]

Hello forum members,
Using Excel 2007 I created a worksheet for my neighbor who runs a restaurant and would like to track the # of orders for each menu item buy just clicking a button corresponding to the items on the menu. I have a Column A for each menu item (142 of them) and then Column B contains Active X spin buttons. Column C is the numeric value of each spin button. I then selected each spin button and using the properties box,manually programed the link for each button to the corresponding cell in Column C. I wanted to then replicate column B & C (which represents one month of sales) and paste to column D & E to create another month (and repeat this) so I literally wouldn't have to create 142 spin buttons and their cell links 11 more times. Copying and pasting worked for all formulas and buttons with the exception of the "linked cell" info. This does not automatically update (the column letters) like my formulas do. Is it possible to do this? As I'm sure you have already deduced I am a "Visual Basic" and "Macro" challenged individual but I thought I'd ask and hopefully learn how to streamline this process. I thank you in advance and I'm sorry for the lengthy post.

[Charlize]

Put a sample sheet with some spinbuttons and the starting layout.

[svpdebbie]

Thanks for looking at this. Here's a very basic layout with a few buttons.

[Charlize]

Maybe you could give this a try.

[svpdebbie]

Charlize-
Works like a charm and so much more streamlined then spin buttons for each month. I really appreciate your response-thank you.

[ExcelMonkey1]

Charlize,
I love what you did with the spreadsheet, and managed to use it for my work. However, do you know if there is a way to get the totals to transfer to a master spreadsheet for a manager to keep track of?