+ Reply to Thread
Results 1 to 2 of 2

Delete both Rows, if a cell is the same

  1. #1
    Registered User
    Join Date
    10-29-2012
    Location
    Utrecht
    MS-Off Ver
    Excel 2007
    Posts
    13

    Delete both Rows, if a cell is the same

    Hi guys,

    I am trying to find a solution to this, to no success. Could you please help me out?

    In my file(attached) in Column D, you can find the exact same date/time in two cells.(as shown in the file)

    Is it possible to have a macro which will be checking the cells for exact same date/time and then to delete both those lines?

    So the end result would be the file attached minus the coloured lines.


    Thank you so very much in advance!


    Ioannis
    Attached Files Attached Files

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Delete both Rows, if a cell is the same

    maybe
    Please Login or Register  to view this content.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find row cell containing specific text, then delete all rows ABOVE that cell
    By ks100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2013, 02:02 PM
  2. [SOLVED] Delete rows if any cell in Sheet 1 rows matches any cell in Sheet2 column
    By newbie88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2012, 10:26 AM
  3. Delete Rows by Cell Value - Delete sheets w/out prompt
    By Jimmydageek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2010, 02:03 PM
  4. Delete rows where active cell is selected without hardcoding cell
    By alexfortin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-19-2009, 06:58 PM
  5. Delete Rows based on cell value and then Insert rows alternatively with a formula
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2008, 04:27 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