+ Reply to Thread
Results 1 to 4 of 4

Moving cells to blank cells

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Moving cells to blank cells

    Hello all. I am wondering if its possible to move 2 adjacent cells say from Column A and B on sheet 2 to sheet 1 column A and B. It needs to search through A and B on sheet 1 to find the 1st to empty adjacent cells and use those together. Hope that makes sense and thanks for any help

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Moving cells to blank cells

    Assuming row 1 on sheet 2:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-08-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Moving cells to blank cells

    So i am trying to combine it with another macro which finds a certain value in column B and moves it and the adjacent text in column A from sheet 2 to sheet 1 then clears the cells in sheet 2 and looks for the next value. Including the code with yours in which i tried to combine them.
    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Moving cells to blank cells

    Who knows. You usually can't just combine two separate codes together and expect them to magically work. If you submit a copy of your workbook with a detailed description of your entire process we could give you a direct answer. Here is a shot in the dark:

    Please Login or Register  to view this content.

+ 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. Moving average excluding blank cells
    By bog3494 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-28-2011, 07:18 PM
  2. Moving rows that contain blank cells to the bottom
    By yfont in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-14-2011, 06:03 PM
  3. Calculating Moving Range with Blank Cells
    By montego in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-16-2010, 11:20 AM
  4. Moving up blank cells
    By sbrimley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-17-2006, 07:45 PM
  5. [SOLVED] 30 Day Moving Average Ignoring Blank Cells
    By ethatch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2006, 05:40 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