Results 1 to 20 of 20

Thread: Delete if value is 0

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-08-2012, 09:47 AM #1
    fatalcore
    fatalcore is offline
    VBAX Regular
    Joined
    May 2011
    Posts
    51
    Location

    Delete if value is 0

    Hi,
    I have a worksheet,
    Now I have two sheet named Face and Metal.
    What I want is a VBA code against the button "Delete" in the sheet "Metal" that, if in the sheet "Face" the value in the column AL is 0 then the entire row will be deleted in the "Metal" sheet.
    The values in Column J in "Face" and Column F in the sheet "Metal" is unique.
    I am uploading a dummy sheet for reference.
    Thanks in advance.
    Attached Files Attached Files
    Last edited by fatalcore; 02-08-2012 at 10:02 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules