+ Reply to Thread
Results 1 to 10 of 10

Find filled cell in column, select corresponding rows and copy only selected cells/columns

  1. #1
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Find filled cell in column, select corresponding rows and copy only selected cells/columns

    I've searched for similar threads but couldn't find suitable one.

    Macro that searches for filled cells in column A-starting at A2 (Sheet1), selects the corresponding rows and copies cells only in columns C, E, G and pastes them to Sheet2 starting in cell A2 to C2. At the same time it should delete previously found filled cells in column A (presented in Sheet1a) and colour them red, because I want the next loop to find only new filled cells in column A (Sheet1).
    When it pastes it to Sheet2 I would need to find last filled row and each time paste it bellow.

    Many thanks for suggestions!
    Attached Files Attached Files
    Last edited by Tona; 11-13-2015 at 01:49 AM.

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,538

    Re: Find filled cell in column, select corresponding rows and copy only selected cells/col

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

  3. #3
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Re: Find filled cell in column, select corresponding rows and copy only selected cells/col

    Hope it will be clearer now.
    Thank you!

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,538

    Re: Find filled cell in column, select corresponding rows and copy only selected cells/col

    Apologies for the late response.

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Re: Find filled cell in column, select corresponding rows and copy only selected cells/col

    Skywriter,

    I appreciate your work! Works perfect.

  6. #6
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,538

    Re: Find filled cell in column, select corresponding rows and copy only selected cells/col

    My pleasure thanks for the rep. points.

    Please click the Thread Tools drop down box above your first post and choose solved.

  7. #7
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Re: Find filled cell in column, select corresponding rows and copy only selected cells/col

    Skywriter,
    is it possible to change the order of moved cells?

    Please Login or Register  to view this content.
    I've tried with the red text, to mix the order but it still takes it 2, 4, 6.



    Many thanks
    Last edited by Tona; 11-17-2015 at 08:41 AM.

  8. #8
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,538

    Re: Find filled cell in column, select corresponding rows and copy only selected cells/col

    Try this:

    Please Login or Register  to view this content.
    I think you probably understand the code, but just to make sure.
    Please Login or Register  to view this content.
    A,B,C is the columns that the data will go into on sheet 2. The 2,4,6 are columns C,F,G on sheet 1. They are offsets from the A column. So you could change the A,B,C or the 2,4,6 which ever is your preference.
    Last edited by skywriter; 11-17-2015 at 10:57 AM.

  9. #9
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Re: Find filled cell in column, select corresponding rows and copy only selected cells/col

    Many thanks!
    And I appreciate the explanation

  10. #10
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Re: Find filled cell in column, select corresponding rows and copy only selected cells/col

    Many thanks!
    And I appreciate the explanation

+ 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. Copy paste based on rows/columns filled
    By bsturds in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2015, 10:27 AM
  2. [SOLVED] Find "Total Hours" by searching entire rows below selected cell vs. cells in a column
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2014, 12:30 PM
  3. Need to find empty filled cells in a column and copy to the empty cell below
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2014, 10:09 AM
  4. Select only filled cells in column to use insert command
    By Nancy Dratwa in forum Excel General
    Replies: 1
    Last Post: 08-19-2013, 11:03 AM
  5. [SOLVED] Select only filled cells of a column and create a text file
    By Sam9 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-03-2013, 08:27 AM
  6. [SOLVED] How to select all records in a empty column between to filled columns
    By boerbende in forum Excel General
    Replies: 3
    Last Post: 11-20-2011, 07:37 AM
  7. [SOLVED] [SOLVED] Select filled cells/rows in a spreadsheet
    By pellerin.thomas@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2005, 08:35 PM

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