In column B I have a bunch of dates. I want a macro to search the column from row 2 down to the last used row and find the first instance of today's date. When it finds it I want to delete the column above where it was found all the way up to row 2. I then want to find the date 14 days from today and search for that date in column B. When it finds that date, delete the row where it is found and all rows below it. Thanks in advance!
Last edited by ScabbyDog; 04-16-2015 at 01:59 PM.
Since I wasn't sure if you want to delete the cells and move the data up, delete the entire rows or delete just the content, I went for the safest solution and deleted the content.
Please Login or Register to view this content.
Enjoy
Last edited by JasperD; 04-16-2015 at 02:37 PM.
Please click the * below if this helps
Maybe:
Please Login or Register to view this content.
Im Slightly late but maybe this:
Please Login or Register to view this content.
They all work but they just delete the content. I want to delete the entire row. Easy change?
Add Entirerow.
Please Login or Register to view this content.
Thanks John and everyone else. All worked fantastic. Great help! Have left you all positive feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks