LinkBack URL
About LinkBacks
I have dates in column G, I would like to delete the line if the date is less than (todays date +28 days). I also need to do this only if column J has "reschedule out" in the cell.
All help appreciated
I have dates in column G, I would like to delete the line if the date is less than (todays date +28 days). I also need to do this only if column J has "reschedule out" in the cell.
All help appreciated
try this: I assumed there was always something in each cell of column A of your table. If not, change A1 and 1 in this line: For Each c_ell In Range("a1", Cells(20000, 1).End(xlUp))
Like if you have column C filled, the line would be:
For Each c_ell In Range("C1", Cells(20000, 3).End(xlUp))
Please Login or Register to view this content.
Last edited by p24leclerc; 06-21-2011 at 06:49 PM.
Please Login or Register to view this content.
I cannot get either of these solutions to work!
hi, bouncey, can you post sample workbook?
Hi Watersev,
Please see attached wb for a before and after. Any help achieving the after would be most appreciated as it takes me about an hour a day do sort. Automating this process would be a god send.
Thanks
please check attachment, run code "test", all the rows with dates less than 20.07.2011 (Today+28 days) and with value "Reschedule out" are deleted
Last edited by watersev; 06-22-2011 at 04:27 PM.
Perfect, thank you.
If you could help with anything else in the before and after wb's I would be most grateful.
what else do you need?
I would like to automate the summary sheet!
Thanks
I would reply tomorrow if you do not mind and no one does it before me
will you accept summary with this layout?
yes, that would be good.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks