Results 1 to 8 of 8

copy and delete rows that have values greater than defined cells

Threaded View

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    29

    copy and delete rows that have values greater than defined cells

    Hi guys

    I have a copy macro that I use as a button to copy a set of data to another worksheet :

    Sub copy()
    '
    ' copy Macro
    ' copy data to partitioned bias work sheet
    '
    
    '
        Range("A1:F303").Select
        Selection.copy
        Sheets("Sheet1").Select
        Range("A1").Select
        ActiveSheet.Paste
        
        
    End Sub

    I would like to put in a function that will delete all rows that that have values greater than set amounts

    ie I would like to remove the row with the two cells highlighted in yellow at the moment I am using conditional formatting to highlight them and doing it manually but i would like to attach it to my copy button above.

    Your help is appreciated

    Josh


    ex.jpg
    Last edited by josh-mediwatch; 05-30-2014 at 06:29 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] delete rows where there are 3 or 4 cells with values > 0
    By Beekster in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-25-2013, 05:06 AM
  2. Delete rows with cell values equal to or greater than current week number
    By Pradeep M B in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2013, 09:39 AM
  3. Need macro to copy rows between two defined values
    By JB87 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-27-2013, 11:40 AM
  4. How to delete all rows if any cells in the row contain certain values.
    By twills in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2010, 03:38 PM
  5. Delete Rows with Value greater than X
    By STEVEB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2005, 04:08 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