+ Reply to Thread
Results 1 to 2 of 2

Moving only selected cells from one column to an adjacent one

  1. #1
    Registered User
    Join Date
    03-05-2016
    Location
    kansas oklahoma
    MS-Off Ver
    office 365
    Posts
    1

    Moving only selected cells from one column to an adjacent one

    I have a spreadsheet where there are random values going down Column C that I want to select and paste into the corresponding row in Column B. The corresponding cells in Column B are always blank. All the cells between the random values in Column C are blank. There is content in the other cells in Column B that I don't want to overwrite, nor do I want to move them at all. I I know I can select the cells in Column C using Go To Special, but once I've identified them, I can't get them to just scoot over one cell. Any ideas?

  2. #2
    Valued Forum Contributor
    Join Date
    01-03-2016
    Location
    Conwy, Wales
    MS-Off Ver
    2016
    Posts
    974

    Re: Moving only selected cells from one column to an adjacent one

    The easiest way is to use another (helper) column
    put this formula in row2 of that column and copy down
    =If (C2<>"",C2,B2)
    The copy the cells in the helper column and PasteSpecial VALUES to columnB

    (NOTE THIS WILL NOT WORK IF COLUMNB CONTAINS FORMULAS - it will overwrite whatever is in columnB with the values from helper column)

+ 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. Compare 2 adjacent cells each with a lot data for selected special match
    By Connemara in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2014, 05:12 PM
  2. [SOLVED] List in Combo Box, when new item is selected put todays date in the adjacent column
    By Antligen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-03-2014, 10:30 AM
  3. Paste values in the selected non-adjacent cells
    By kmahesh in forum Excel General
    Replies: 2
    Last Post: 07-05-2013, 01:01 PM
  4. Replies: 3
    Last Post: 07-30-2012, 11:20 AM
  5. Replies: 1
    Last Post: 09-27-2011, 05:20 PM
  6. Moving one long column into adjacent columns
    By mugarolla in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2010, 11:41 AM
  7. Moving multiple values from Column A to adjacent columns
    By marker61 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2009, 02:34 AM

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