Thanks:  0
Likes:  0

Thread: copying with 10 cells at a time

1. i have data from A1 to A93
i want to copy A3:A13:A23:A33 and so on
to F1:F2:F3:F4...and so on
data is text
a
1 D
2 F
3 C
4 R
5 G
6 Y
and i want to copy them like i said at the begginning so through f1 to f whatever it will look like
C (a3)
Y (a6)

2. On 2002-04-18 09:13, Mert wrote:
i have data from A1 to A93
i want to copy A3:A13:A23:A33 and so on
to F1:F2:F3:F4...and so on
data is text
a
1 D
2 F
3 C
4 R
5 G
6 Y
and i want to copy them like i said at the begginning so through f1 to f whatever it will look like
C (a3)
Y (a6)
Why does column F look like:
A3
A6

What happened to A4, A5?

3. i think i said it the wrong way
for example i have names of people from a1 to a100
and i want to copy the names to a different column lets say column f
but i want to copy every 10 row of column a
example a1 then a10 and a20 and so on till the end.
if a1 has the name "john" then it should copy the name to f1
then a10 has the name "al" then f2 has the name al and so on
any formula for this
thanx

4. Maybe you don't need a macro. Setup column F as follows:
F1=A1
F2==OFFSET(A1,9,0)
Then copy F2 down until you run out of names.

5. NO ÝT DOESNT WORK

6. Why not?

7. Hi Mert,

not sure where your "Y" in "A6" comes from as you say you want the value of A13 not A6...

anyhows, assuming you want F1:F2:F3:F4 to hold values from A3:A13:A23:A33 etc etc etc

then try the following in F1 and copy down :

=INDIRECT("A"&(ROW()*10)-7)

_________________
Hope this helps,
Chris

marker

[ This Message was edited by: Chris Davison on 2002-04-18 13:21 ]

[ This Message was edited by: Chris Davison on 2002-04-18 14:45 ]

8. Thanks
Great Help

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•