+ Reply to Thread
Results 1 to 3 of 3

Paste values in the selected non-adjacent cells

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003
    Posts
    93

    Paste values in the selected non-adjacent cells

    Hi all,

    I want a solution for the following problem.

    Sometimes I need to copy the values in adjacent/continuous cells and paste them
    into the cells which I select and which are not adjacent/continuous.

    Like for example i want to copy values from A1:A4 and paste in C1,C4,C7,&C10

    help please

    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Paste values in the selected non-adjacent cells

    You could always write a formula that jumps your cell every 4 or so. But for that you'd need a helper column. Do they occur sporadically or every 3 as you indicate in the sheet?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Paste values in the selected non-adjacent cells

    Here is how I would do it attached.
    I would add a couple helper columns.
    First, insert a column beside your column A, then begin numbering them such as I did. After you put in the first three numbers, 1, 4 and 7, excel will recognize the pattern. Just double click on the corner and it will autopopulate for the rest. Then I added another helper cell, column F and I would do a vlookup in column D and it would return the values you want. (I did them in col E but you can do them in D where you want the results.)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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