Results 1 to 6 of 6

Deleting Rows in Sheet 1 conditioning on Values in Sheet 2

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2015
    Location
    Bangkok
    MS-Off Ver
    2007
    Posts
    28

    Deleting Rows in Sheet 1 conditioning on Values in Sheet 2

    hi, I have a long range of data, with the first Column A being the date in the form MM/DD/YYYY,
    the date ranges from 1/1/2004 until 12/31/2014.
    These data is in "Sheet 1"

    I would like to however keep only some of the dates by deleting the entire row for the dates I dont want.
    The dates I would like to keep are listed in "Sheet 2" column A

    Could anyone please help me implement this Macro, would highly appreciate your time for it.
    I've attached the file as reference.

    Thank you in advance.

    VKu
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding or deleting rows in master sheet and automatically update target sheet
    By RLR31064 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2014, 01:39 PM
  2. [SOLVED] Deleting rows from sheet 1 when table on sheet 2 does not have the data anymore
    By charscribbles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2014, 09:39 PM
  3. Deleting rows on one sheet based on a condition in another sheet in the same file
    By Steve2107 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2014, 06:48 AM
  4. Changing code from deleting rows to cut/paste rows into another sheet and delete blank row
    By kmarshall6576 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2013, 01:54 AM
  5. [SOLVED] deleting rows depending on values on another sheet
    By ghynes in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-07-2013, 07:16 PM

Tags for this Thread

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