+ Reply to Thread
Results 1 to 2 of 2

copying and pasting multiple non-contiguous cells PRESERVING THEIR RELATIVE LOCATIONS

  1. #1
    Forum Contributor
    Join Date
    02-13-2016
    Location
    CT USA
    MS-Off Ver
    office 365 subscription
    Posts
    178

    copying and pasting multiple non-contiguous cells PRESERVING THEIR RELATIVE LOCATIONS

    I wish to copy multiple non-contiguous cells in a column retaining their relative row locations.

    Then paste those copied cells in another column on that same spreadsheet starting at
    the same row in the new column.

    The paste results in all the correct cell values and formulas but does not preserve
    their relative location. I get a contiguous set of numbers in cells

    CAn anyone help me copy and paste multiple non-contiguous cells AND preserve their relative locations.


    bil
    Last edited by whburling; 10-04-2019 at 07:44 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: copying and pasting multiple non-contiguous cells PRESERVING THEIR RELATIVE LOCATIONS

    This requires a macro. As luck would have it, I wrote such a macro a while back. This code is in my PERSONAL.xlsb workbook. This also requires two sheets with codenames OverlayScratch and OverlayClipboard. I put a button on the QAT to run it.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] pasting relative formula in cells
    By esbencito in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-21-2018, 01:38 AM
  2. Copying non-contiguous cells from one worksheet to another in a different order
    By Bigfoot17 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2016, 11:21 AM
  3. skipping a row when copying and pasting relative references
    By DvDj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2016, 02:05 PM
  4. [SOLVED] Relative locations to absolute locations using VBA
    By lostest in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2015, 06:30 PM
  5. Pasting the locations of selected cells
    By llgn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2012, 12:15 PM
  6. Replies: 0
    Last Post: 11-15-2007, 02:41 AM
  7. pasting non-contiguous range of cells to new row, same cell locati
    By Not excelling at macros in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-04-2006, 04:10 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1