copying with 10 cells at a time

Mert

New Member
Joined
Apr 17, 2002
Messages
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
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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?
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,238
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top