VBA select in drop down list

[CassieL]

Hi everyone,


I want to build a macro where I have it go to C3 and select next item in the drop down list. For example dropdown list: "1,2,3,4,5,6,7,8,9,10"


For example in sheet1 C3, it picks "1" in drop down list, sheet2 C3, it picks "2" in the drop down list.... and so on. How can I do that. Please help and I am ready to learn.


Thanks,
CassL