+ Reply to Thread
Results 1 to 3 of 3

Delete rows based on matching dates in Sheet1 Column A with date in Sheet2 Cell K1

  1. 11-24-2015, 02:11 PM #1
    robertaw is offline
    Registered User
    Join Date
    12-03-2012
    Location
    cheltenham
    MS-Off Ver
    Excel 2007
    Posts
    2

    Delete rows based on matching dates in Sheet1 Column A with date in Sheet2 Cell K1

    Hi I am tring to delete any row which has a date in sheet 1 col A which matches the date in Sheet2 K1

    but am getting nowhere fast! Can anyonehelp please?
    Reply With QuoteRegister To Reply
  2. 11-24-2015, 02:16 PM #2
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Delete rows based on matching dates in Sheet1 Column A with date in Sheet2 Cell K1

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 11-24-2015, 02:30 PM #3
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Delete rows based on matching dates in Sheet1 Column A with date in Sheet2 Cell K1 

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.
    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. [SOLVED] Need to copy a row from Sheet1 to Sheet2 then auto delete from Sheet 1 based on Column G
    By jingles9 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2015, 08:11 AM
  2. move data from sheet1 to sheet2 based on date in column1 of sheet1
    By pcaldwell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-10-2014, 03:20 PM
  3. [SOLVED] copy data from sheet1 to sheet2 based on column (A) sheet1 and column (C) sheet2
    By AWITCHER in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-13-2014, 03:20 PM
  4. Insert/Delete record in Sheet2 based on cell value in Sheet1
    By nseethar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2014, 02:29 AM
  5. reading cell in sheet1 and matching it to the corresponding value in sheet2
    By nina0909 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-30-2012, 02:59 AM
  6. Macro to copy range of cell from sheet1 to sheet2 based on a cell value in sheet2
    By drgwhizz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2012, 10:39 AM
  7. Delete from Sheet1 the rows that are also on Sheet2
    By email4kh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2010, 10:48 AM

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