Given the following data in Row A (one number per column)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
set that aside for a moment.

if, separately, you type
2 4 6
and then highlight these three cells drag the autofill to the right, you get
2 4 6 8 10 12 14 16 18

But, if you type
=A2 =A4 =A6
and highlight these cells and drag to the right with autofill, you get
=A2 =A4 =A6 =A5 =A7 =A9 =A8 =A10 =A12

What I want is to use autofill or other means(in other words, NOT to
have to hand code each cell) to create
=A2 =A4 =A6 =A8 =A10 =A12 =A14 =A16

One possible solution I thought of is to create the series 2,4,6,8,10,
then concatanate with the letter A to get the right strings as text in
the cell.  But I don't know how to then force the program to evaluate
that text as an actual formula.

Thanks!