Results 1 to 4 of 4

Copy/Paste Certain Cells matching criteria

Threaded View

dvs12c Copy/Paste Certain Cells... 06-18-2009, 07:14 AM
StephenR Re: Copy/Paste Certain Cells... 06-18-2009, 07:20 AM
dvs12c Re: Copy/Paste Certain Cells... 06-18-2009, 09:04 AM
StephenR Re: Copy/Paste Certain Cells... 06-18-2009, 11:05 AM
  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.

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