Results 1 to 3 of 3

Copy if cell greater then zero

Threaded View

Bob@Sun Copy if cell greater then zero 11-24-2009, 03:46 PM
mrice Re: Copy if cell greater then... 11-24-2009, 04:03 PM
Bob@Sun Re: Copy if cell greater then... 11-26-2009, 03:56 PM
  1. #1
    Forum Contributor Bob@Sun's Avatar
    Join Date
    09-03-2009
    Location
    Montuak, Usa
    MS-Off Ver
    Excel 2007
    Posts
    438

    Copy if cell greater then zero

    Hello,

    I have one sheet where I am entering the necessary parts of the particular order. Once I have it completed I need to run a macro to copy only the elements that I have marked.

    From rows 3-17, if cells in E3-E15 are greater then 0 then I need the rows
    from Column "C" to Column "G" and Column "I" copied to another sheet.

    With rows 20 - 97 if cell in column "E" is > 0 then copy the relevant row from
    column "B" to column "E"

    I am attaching the file and will appreciate if you can help me with the code.

    Thanks in advance!
    Attached Files Attached Files
    Last edited by Bob@Sun; 11-26-2009 at 03:57 PM.

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