Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: copying with 10 cells at a time

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #4
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    NO ÝT DOESNT WORK

  6. #6
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why not?

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #8
    New Member
    Join Date
    Apr 2002
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks
    Great Help

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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