Results 1 to 9 of 9
  • Thread Tools
  1. 3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste every other cell (Excel 2003)

    I have a need to copy cells A1, A3, A5 and I want to past them in A101, A103, and A105. I know I can copy all three at once by holding down the ctrl key, but when I go to paste they paste in A101, A102, A103. Is there a way to have them paste in the proper cells (every other row). Thank you.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste every other cell (Excel 2003)

    You could do it with a macro:

    <pre>Public Sub CopyThree()
    ActiveSheet.Range("A1").Copy Destination:=Range("A101")
    ActiveSheet.Range("A3").Copy Destination:=Range("A103")
    ActiveSheet.Range("A5").Copy Destination:=Range("A105")
    End Sub
    </pre>

    Legare Coleman

  4. WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    10,924
    Thanks
    11
    Thanked 278 Times in 272 Posts

    Re: Paste every other cell (Excel 2003)

    Select A1:A5 (the entire range, not the individual cells)
    Copy
    Select A101
    Paste

    You can then delete A102 and A104 if A2 and A4 had something in them.

    Steve

  5. Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste every other cell (Excel 2003)

    Won't that also copy A2 to A102 and A4 to A104?
    Legare Coleman

  6. 3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste every other cell (Excel 2003)

    No, this will not work because there are different formulas in A102 and A104 and A106 that would be destroyed with this approach. Thank you.

  7. 3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste every other cell (Excel 2003)

    I did not want to use a macro because the amount of cells to copy and paste will vary throughout this spreadsheet. Thank you anyway.

  8. Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste every other cell (Excel 2003)

    Is the location to paste always 100 rows below the first copied cell? If so, some slightly more complicated code could handle it.

    <pre>Public Sub CopyToRow100()
    Dim oCell As Range
    For Each oCell In Selection
    oCell.Copy Destination:=oCell.Offset(100, 0)
    Next oCell
    End Sub
    </pre>

    Legare Coleman

  9. 3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste every other cell (Excel 2003)

    That's it. Thank you.

  10. WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    10,924
    Thanks
    11
    Thanked 278 Times in 272 Posts

    Re: Paste every other cell (Excel 2003)

    I had (incorrectly) assumed that A2 and A4 were blank, and after posting realized that might not be correct, and then edited my post to delete A102 and A104.

    But even that is incorrect, and you have already posted a good solution. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

    Steve

Posting Permissions

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