+ Reply to Thread
Results 1 to 13 of 13

Copy cells to a new sheet spacing out the destination cells

  1. 11-04-2014, 03:01 PM #1
    brianrhoff
    brianrhoff is offline
    Registered User
    Join Date
    12-31-2013
    Location
    ny
    MS-Off Ver
    Excel 2003
    Posts
    8

    Copy cells to a new sheet spacing out the destination cells

    Hello!

    I would first like to thank anyone in advance for their help. I love this forum and am very grateful for it.

    I am trying to take cells from one sheet and paste them to another. Sounds easy enough. The only caveat is the destination cells are spaced out differently than the original cells.

    Example:

    I need the data from:

    sheet 1 A81 & B81 to go to sheet 3 A5 & B5
    sheet 1 A82 & B82 to go to sheet 3 A30 & B30
    sheet 1 A83 & B83 to go to sheet 3 A55 & B55

    it's thousands of lines of data that I would probably die before completing manually.

    Thanks for your help everyone!!!
    Reply With QuoteRegister To Reply
  2. 11-04-2014, 03:10 PM #2
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Copy cells to a new sheet spacing out the destination cells

    Hello brianrhoff,

    it's thousands of lines of data... ?
    I cannot see where that would come from, with the info you have posted.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  3. 11-04-2014, 03:15 PM #3
    brianrhoff
    brianrhoff is offline
    Registered User
    Join Date
    12-31-2013
    Location
    ny
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Copy cells to a new sheet spacing out the destination cells

    I need the data from:

    sheet 1 A81 & B81 to go to sheet 3 A5 & B5
    sheet 1 A82 & B82 to go to sheet 3 A30 & B30
    sheet 1 A83 & B83 to go to sheet 3 A55 & B55
    ......
    .....
    ...
    And so on
    Reply With QuoteRegister To Reply
  4. 11-04-2014, 03:39 PM #4
    brianrhoff
    brianrhoff is offline
    Registered User
    Join Date
    12-31-2013
    Location
    ny
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Copy cells to a new sheet spacing out the destination cells

    Paste Pic.png




    Copy Pic.jpg




    I need the colored arrows to copy from the long list of information on the first and past to the individual boxes on the other sheet.
    Last edited by brianrhoff; 11-04-2014 at 03:43 PM.
    Reply With QuoteRegister To Reply
  5. 11-04-2014, 03:43 PM #5
    brianrhoff
    brianrhoff is offline
    Registered User
    Join Date
    12-31-2013
    Location
    ny
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Copy cells to a new sheet spacing out the destination cells

    Attachment 356515


    Pasted to here.
    Reply With QuoteRegister To Reply
  6. 11-04-2014, 03:56 PM #6
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Copy cells to a new sheet spacing out the destination cells

    Hello brianrhoff,

    How to attach a sample workbook.

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Reply With QuoteRegister To Reply
  7. 11-04-2014, 03:58 PM #7
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy cells to a new sheet spacing out the destination cells

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 11-04-2014, 04:03 PM #8
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Copy cells to a new sheet spacing out the destination cells

    @ JOHN H. DAVIS,

    Thanks for helping here John. I was very tempted to also assume 25 Rows, but have decided to make sure.

    Regards.
    Reply With QuoteRegister To Reply
  9. 11-04-2014, 04:20 PM #9
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy cells to a new sheet spacing out the destination cells

    @ Winon - Glad to help out, not a problem at all.
    Reply With QuoteRegister To Reply
  10. 11-04-2014, 04:52 PM #10
    brianrhoff
    brianrhoff is offline
    Registered User
    Join Date
    12-31-2013
    Location
    ny
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Copy cells to a new sheet spacing out the destination cells

    Cool! Now I just have to figure out how to put a macro into my spreadsheet and I'm good to go. Thanks guys.
    Reply With QuoteRegister To Reply
  11. 11-04-2014, 08:10 PM #11
    brianrhoff
    brianrhoff is offline
    Registered User
    Join Date
    12-31-2013
    Location
    ny
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Copy cells to a new sheet spacing out the destination cells

    Thanks so much guys it worked!!!!! Can you help me out with one more thing?

    What if I wanted to copy just one column of data over but still wanted to space the pasting destinations out by 25 cells?
    Reply With QuoteRegister To Reply
  12. 11-06-2014, 07:16 AM #12
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy cells to a new sheet spacing out the destination cells

    If the Column were "A".

    Please Login or Register  to view this content.
    For learning materials, a good start is here:

    http://www.excelforum.com/excel-prog...materials.html
    Last edited by JOHN H. DAVIS; 11-06-2014 at 07:24 AM.
    Reply With QuoteRegister To Reply
  13. 11-06-2014, 01:07 PM #13
    brianrhoff
    brianrhoff is offline
    Registered User
    Join Date
    12-31-2013
    Location
    ny
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Copy cells to a new sheet spacing out the destination cells

    Is it possible to paste a formula for this last one? The data from the 1st sheet will change and I need it to reflect appropriately on the 3rd sheet when it's changed.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. copy specific cells from multiple .xlsx files into a table in destination file
    By khhleung in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-09-2014, 07:18 PM
  2. VBA copy cells to same destination row as the first pasted cell
    By Amanda, in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2014, 08:30 AM
  3. Copy cells with text and pics to new cells while retaining all formatting and spacing?
    By Trismos in forum Excel General
    Replies: 1
    Last Post: 10-13-2013, 04:01 PM
  4. [SOLVED] Copy paste cells containing formulas w/o the destination cells in formulas changing.
    By Rixonomic in forum Excel General
    Replies: 5
    Last Post: 11-03-2012, 05:10 PM
  5. Leave destination cells blank when origin cells contain value 0
    By vince2g in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2010, 11:24 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1