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

in macro code cell A1 is cells(1,1)

cell B5 is cells(5,2)

so you need to write a simple macro along the lines of

for j=1 to 1100 step 10
cells(j,1)="A"
next j
end

if your data to be inserted is in a list in column Z try

for j=1 to 1100 step 10
sum=sum+1
cells(j,1)=cells(sum,26)
next j
end


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

in macro code cell A1 is cells(1,1)

cell B5 is cells(5,2)

so you need to write a simple macro along the lines of

for j=1 to 1100 step 10
cells(j,1)="A"
next j
end

if your data to be inserted is in a list in column Z try

for j=1 to 1100 step 10
sum=sum+1
cells(j,1)=cells(sum,26)
next j
end


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

Cheers, I'll give it a go. I'd have thought there was a more simpler way
to do it though!


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

Cheers, I'll give it a go. I'd have thought there was a more simpler way
to do it though!


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

"geoff1234" wrote in
message ...

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?

If your 1,2,3 are in A1, A2, A3, etc.
then in B1 use
=1+10*(A1-1)
and copy down.
--
David Biddulph