Copy Forms (combo boxes & checkboxes) down many cells & auto. increment cell links

Hello everybody,

I have a spreadsheet we received from one of our customers of about 5000+ store sites. I've added several columns for use within our company. These columns consist of several combo boxes and a checkbox. I'd like to be able to copy these down the column, but if I do so in the normal fashion it will use the same "cell link" in each cell. The result of this is that when you change a value in one cell, it copies it to all the rest of them. I'm sure there's an easy way to do this with a formula, but I don't have my Office book handy.

What's the quick fix?

Thank you for your help!

I have the exact same question. Did you ever get a solution to this issue?

Does anyone have or know a solution to this?