copying with 10 cells at a time

Mert · Apr 18th, 2002, 10:13 AM

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)
help please

Al Chara · Apr 18th, 2002, 10:20 AM

Quote:

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)
help please

Why does column F look like:
A3
A6

What happened to A4, A5?

Mert · Apr 18th, 2002, 10:27 AM

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

Al Chara · Apr 18th, 2002, 11:02 AM

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.

Mert · Apr 18th, 2002, 11:08 AM

NO ÝT DOESNT WORK

Al Chara · Apr 18th, 2002, 11:09 AM

Why not?

Chris Davison · Apr 18th, 2002, 02:21 PM

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 ]

Mert · Apr 20th, 2002, 09:45 AM

Thanks
Great Help

Apr 18th, 2002, 11:02 AM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 10:13 AM	#1
Mert New Member Join Date: Apr 2002 Posts: 20	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) help please

Apr 18th, 2002, 10:27 AM	#3
Mert New Member Join Date: Apr 2002 Posts: 20	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

Apr 18th, 2002, 11:08 AM	#5
Mert New Member Join Date: Apr 2002 Posts: 20	NO ÝT DOESNT WORK

Apr 18th, 2002, 11:09 AM	#6
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Why not?

Apr 18th, 2002, 02:21 PM	#7
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ]

Apr 20th, 2002, 09:45 AM	#8
Mert New Member Join Date: Apr 2002 Posts: 20	Thanks Great Help