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
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