1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Other VB Help: Copy cells to sheet on cell criteria

Discussion in 'Software' started by jopers1986, 2 Feb 2010.

  1. jopers1986

    jopers1986 Member

    Joined:
    7 Jan 2005
    Posts:
    559
    Likes Received:
    4
    Hi Guys,

    I've having some issues, found odds and ends of code that partially work, but can't get them to do just what i want.

    i have 2 main sheets, Data and Archive.

    Basically what i want to do is click a button that will copy all rows, from row 10 down, where the value in column P for that row is a value (<> "") to the archive sheet.

    Is this possible?

    Thanks for advance for any help!

    Rich
     
  2. jopers1986

    jopers1986 Member

    Joined:
    7 Jan 2005
    Posts:
    559
    Likes Received:
    4
    Any ideas please? i'm getting desperate!

    Thanks
     
  3. Landy_Ed

    Landy_Ed Combat Novice

    Joined:
    6 May 2009
    Posts:
    1,428
    Likes Received:
    39
    Have you tried recording a macro while performing the actions you want to achieve manually? Once you've got the base code generated, the rest can be added later.
     

Share This Page