+ Reply to Thread
Results 1 to 4 of 4

Copy/Paste Certain Cells matching criteria

  1. #1
    Registered User
    Join Date
    06-18-2009
    Location
    Sydney,Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    2

    Copy/Paste Certain Cells matching criteria

    Looking to get some macro coding for:

    Macro will search a row for a "x" (x is a =if(today(),"x","")



    when it finds the x it will then look down the coloumn and find any empty cell down to 300 and copy each coloumns.row (a:b) and paste it into another sheet

    I would also like it to search only for 2 different names in those coloumns and only copy them so it may only copy 50ish.

    eg
    a---b--------c d e-----f g h i j
    ________________________
    -------------------x
    1---Name
    2---Name-----Away
    3---Name-----Away
    4---Name
    5---Name
    300


    -1 should be copied because it empty but only want to copy 4 and 5. Wont copy the "Away" rows!

    This is what i want to see come from it:

    4---Name
    5---Name


    Thanks

    (Eg didnt quick work the way i wanted sorry)
    Last edited by dvs12c; 06-18-2009 at 07:19 AM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Copy/Paste Certain Cells matching criteria

    Please attach a small sample workbook including desired results.

  3. #3
    Registered User
    Join Date
    06-18-2009
    Location
    Sydney,Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    2

    Re: Copy/Paste Certain Cells matching criteria

    Thanks i have attached something similar
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Copy/Paste Certain Cells matching criteria

    If you unmerge the cells and place "Away" in each of them then I think this code should work. Merged cells always cause problems.
    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)

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