help with paste

[yauco]

Hello and thank you,

I enter data in cells a2 to g2, a3 to g3, a4 to g4, etc.
These cells are then referenced from J19 to J25, where I have the formatting in a formula.
J18 =start
J19 = a2
J20 = b2
J21 = c2
J22 = d2, e2
J24 = f2
J25 = g2
J26 =End

Now, when I copy J18 through J26, and paste in J27, J27 references A10, which is the number of lines skipped. Is their a way to make J27 = A3, J28 = B3, J29 = C3, etc. I tried using 'Paste Special' with no change. I'm thinking about maybe using a custom list, but I don't know how to set it up.

PS: I forgot. I'm using Excel 7.0

Thanks,
Jorge

 

[ravishankar]

Hi
insert the formula
J27=INDIRECT(CHAR(ROW()-26+64) & 3)
drag it till J33 or whichever cell you need
Ravi

 

[Peter_SSs]

Jorge

If you copy J18:J26 to J27, why isn't ...
J27 = start,
J28 = A3
J29 = B3
etc?