+ Reply to Thread
Results 1 to 3 of 3

Insert data from one column into the empty cells of an adjacent column

  1. #1
    Forum Contributor
    Join Date
    01-18-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    128

    Insert data from one column into the empty cells of an adjacent column

    Need a macro, please.
    I have numbers in column A in every second cell. Alternating cells are blank. I would like to insert numbers from column B into the blank cells of column A.
    So data in column A are in rows 1,3,5,7, etc.
    Data in clumn B are in rows 2,4,6,8, etc.
    Thank you for any help.

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Insert data from one column into the empty cells of an adjacent column

    see attached example.
    does that work for you?
    you didn't mention if you wanted to erase data from column B after copying to Col. A.

    modytrane.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-18-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    128

    Re: Insert data from one column into the empty cells of an adjacent column

    Thanks very much; this is good.

+ 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