Hi
I am trying to build a table (excel 2007) to count the number of different types products from our different stores. We used to just update numbers of products been sold for each store, but now I want to add a spin button to each cell, and incremental value will be 1 for each spin button.
I added one spin button and then tried to copy it to other cells. However, the cells link address won't be changed. No matter how many buttons I copy, they all address to the first cell I set before.
I really don't want to change their cell links one by one, and please Let me know is there any easier ways to add a spin button to each cell in a certain range?
The file attached is a sample file. I hope to know the method how to do that instead of just making this one, because I have about 20 similar tables need to be modified in the future.
Thank you
test.xlsx
Bookmarks