[xbot]

Here's what I want to do: it's easier to explain with an illustration, so here it is:



In pink is what I've entered. The important term is the first argument in the CHOOSE function. When I use autofill, the blue is what appears. I don't want Turn!C22 to appear next, I want Turn!6 in line 22. And in line 31, I want Turn!C7, not Turn!C23.

Obviously, autofill isn't an option. I have to do this a lot throughout the sheet (usability reasons more than anything else) so any ideas? Autofill will do it correctly if it's just a number in the cells, but if it's a cell reference, it doesn't. I've got very limited Visual Basic knowledge, so any help would be appreciated.

(PS, is the image too big, or should I edit and link it instead?)

[Shades of Gray]

I sent you a PM to point you to a solution. If that moves in the direction, we can modify for the Mac version.

[xbot]

Thanks for the reply.

I tried using applescript to solve the problem instead and it did the job.