+ Reply to Thread
Results 1 to 4 of 4

Code to delete row based of cell criteria

  1. 06-19-2017, 05:38 AM #1
    Excelski
    Excelski is offline
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Code to delete row based of cell criteria

    Hi,

    I need a code to delete an enire row in sheet 1 based on the criteria of A1 in sheet 2 (where i find the correct row)
    This I would then like to paste in the first empty row in sheet 3

    I am new to code

    Any help greatly apricated

    Kevin
    Reply With QuoteRegister To Reply
  2. 06-19-2017, 06:20 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Code to delete row based of cell criteria

    Hi Excelski

    This should give you an idea...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 06-19-2017, 09:10 AM #3
    Excelski
    Excelski is offline
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Code to delete row based of cell criteria

    Hi sincek,

    Thank you very much, worked great!

    Kevin
    Reply With QuoteRegister To Reply
  4. 06-19-2017, 09:35 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Code to delete row based of cell criteria

    Pleasure Kevin....Glad i could help. thanks for rep +
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. modlify vba code to delete rows based on mutliple criteria and multiple sheet
    By Masa1989 in forum Excel General
    Replies: 4
    Last Post: 05-18-2016, 03:48 AM
  2. VBA Code to delete from row 2 based on 2 criteria
    By tommagpieconsultants in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2016, 04:42 PM
  3. [SOLVED] VB Code to Delete value of cell if criteria is met
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-14-2015, 11:44 AM
  4. Delete columns & Row based on criteria VBA code needed
    By Gary B in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-28-2014, 02:59 PM
  5. Code troubles - Trying to copy a row to another sheet based on criteria, then delete
    By kurt1985 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-21-2014, 10:48 AM
  6. Delete Row Based On Cell Criteria
    By NewExcelUser in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-06-2011, 06:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1