Help! Equally spaced cell reference

[geoff1234]

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

 

[robert111]

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]

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

 

[geoff1234]

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

 

[geoff1234]

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

 

[David Biddulph]

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.