Can anyone help with the following please:

On one work sheet I have data equally spaced vertically, ie cell 1 is
A, cell 11 is B, cell 21 is C etc...

On another worksheet I want to make a list of A,B,C... ie 1 maps to 1,
2 maps to 11, 3 maps to 21 and so on.

Is there a way I can automate/autofill this. This is a simplicfication
of the problem but I can't find a way to do it. Any idead?

Cheers

Geoff


--
geoff1234
------------------------------------------------------------------------
geoff1234's Profile: http://www.excelforum.com/member.php...o&userid=36051
View this thread: http://www.excelforum.com/showthread...hreadid=558410