|
how do I delete a row automatically after each date
how do I delete a row automatically after each date is over
|
how do I delete a row automatically after each date
You can embed code similar to the following on an selection change event for
the sheet For Each cl In ActiveSheet.UsedRange.Cells If cl.Value < Now Then ActiveSheet.Rows(cl.Row).Delete End If Next -- http://HelpExcel.com "delete automatically" wrote: how do I delete a row automatically after each date is over |
how do I delete a row automatically after each date
Where do I copy it too?
Thanks for your help "galimi" wrote: You can embed code similar to the following on an selection change event for the sheet For Each cl In ActiveSheet.UsedRange.Cells If cl.Value < Now Then ActiveSheet.Rows(cl.Row).Delete End If Next -- http://HelpExcel.com "delete automatically" wrote: how do I delete a row automatically after each date is over |
how do I delete a row automatically after each date
So, are saying , everything in that row will be deleted after that date?
"galimi" wrote: I have copied an example to http://HelpExcel.com/examples -- http://HelpExcel.com "delete automatically" wrote: Where do I copy it too? Thanks for your help "galimi" wrote: You can embed code similar to the following on an selection change event for the sheet For Each cl In ActiveSheet.UsedRange.Cells If cl.Value < Now Then ActiveSheet.Rows(cl.Row).Delete End If Next -- http://HelpExcel.com "delete automatically" wrote: how do I delete a row automatically after each date is over |
how do I delete a row automatically after each date
Correct. Try entering a date prior to today. You will notice that the
entire row will delete automatically. -- http://HelpExcel.com "delete automatically" wrote: So, are saying , everything in that row will be deleted after that date? "galimi" wrote: I have copied an example to http://HelpExcel.com/examples -- http://HelpExcel.com "delete automatically" wrote: Where do I copy it too? Thanks for your help "galimi" wrote: You can embed code similar to the following on an selection change event for the sheet For Each cl In ActiveSheet.UsedRange.Cells If cl.Value < Now Then ActiveSheet.Rows(cl.Row).Delete End If Next -- http://HelpExcel.com "delete automatically" wrote: how do I delete a row automatically after each date is over |
how do I delete a row automatically after each date
Galmini,
were almost there, I have the dates in column A row 1 I also have other stuff in columns 2 thru 10. The date in column 1 delets but everything to the right stays there. What I'm looking for is to delete the whole row when that date ends. Thanks for your patients "galimi" wrote: Correct. Try entering a date prior to today. You will notice that the entire row will delete automatically. -- http://HelpExcel.com "delete automatically" wrote: So, are saying , everything in that row will be deleted after that date? "galimi" wrote: I have copied an example to http://HelpExcel.com/examples -- http://HelpExcel.com "delete automatically" wrote: Where do I copy it too? Thanks for your help "galimi" wrote: You can embed code similar to the following on an selection change event for the sheet For Each cl In ActiveSheet.UsedRange.Cells If cl.Value < Now Then ActiveSheet.Rows(cl.Row).Delete End If Next -- http://HelpExcel.com "delete automatically" wrote: how do I delete a row automatically after each date is over |
how do I delete a row automatically after each date
I've corrected the code and put it at
http://HelpExcel.com/examples It's named autoDelete.xls This will delete the entire row. -- http://HelpExcel.com 516-984-0252 "delete automatically" wrote: Galmini, were almost there, I have the dates in column A row 1 I also have other stuff in columns 2 thru 10. The date in column 1 delets but everything to the right stays there. What I'm looking for is to delete the whole row when that date ends. Thanks for your patients "galimi" wrote: Correct. Try entering a date prior to today. You will notice that the entire row will delete automatically. -- http://HelpExcel.com "delete automatically" wrote: So, are saying , everything in that row will be deleted after that date? "galimi" wrote: I have copied an example to http://HelpExcel.com/examples -- http://HelpExcel.com "delete automatically" wrote: Where do I copy it too? Thanks for your help "galimi" wrote: You can embed code similar to the following on an selection change event for the sheet For Each cl In ActiveSheet.UsedRange.Cells If cl.Value < Now Then ActiveSheet.Rows(cl.Row).Delete End If Next -- http://HelpExcel.com "delete automatically" wrote: how do I delete a row automatically after each date is over |
how do I delete a row automatically after each date
Is there a way I can send you a example of what i'm talking about?
"delete automatically" wrote: Galmini, were almost there, I have the dates in column A row 1 I also have other stuff in columns 2 thru 10. The date in column 1 delets but everything to the right stays there. What I'm looking for is to delete the whole row when that date ends. Thanks for your patients "galimi" wrote: Correct. Try entering a date prior to today. You will notice that the entire row will delete automatically. -- http://HelpExcel.com "delete automatically" wrote: So, are saying , everything in that row will be deleted after that date? "galimi" wrote: I have copied an example to http://HelpExcel.com/examples -- http://HelpExcel.com "delete automatically" wrote: Where do I copy it too? Thanks for your help "galimi" wrote: You can embed code similar to the following on an selection change event for the sheet For Each cl In ActiveSheet.UsedRange.Cells If cl.Value < Now Then ActiveSheet.Rows(cl.Row).Delete End If Next -- http://HelpExcel.com "delete automatically" wrote: how do I delete a row automatically after each date is over |
how do I delete a row automatically after each date
here is an example
A B C 1 12/20/06 Bill 6am to 2pm Tom 2pm to 10 pm 2 12/21/06 Dan 6am to 2pm carl 2pm to 10 pm 3 12/20/06 Bill 6am to 2pm Tom 2pm to 10 pm 4 12/21/06 Dan 6am to 2pm carl 2pm to 10 pm when 12/20 is over I want row 1 to be deleted Sorry about being a pain but thanks for your help "galimi" wrote: I've corrected the code and put it at http://HelpExcel.com/examples It's named autoDelete.xls This will delete the entire row. -- http://HelpExcel.com 516-984-0252 "delete automatically" wrote: Galmini, were almost there, I have the dates in column A row 1 I also have other stuff in columns 2 thru 10. The date in column 1 delets but everything to the right stays there. What I'm looking for is to delete the whole row when that date ends. Thanks for your patients "galimi" wrote: Correct. Try entering a date prior to today. You will notice that the entire row will delete automatically. -- http://HelpExcel.com "delete automatically" wrote: So, are saying , everything in that row will be deleted after that date? "galimi" wrote: I have copied an example to http://HelpExcel.com/examples -- http://HelpExcel.com "delete automatically" wrote: Where do I copy it too? Thanks for your help "galimi" wrote: You can embed code similar to the following on an selection change event for the sheet For Each cl In ActiveSheet.UsedRange.Cells If cl.Value < Now Then ActiveSheet.Rows(cl.Row).Delete End If Next -- http://HelpExcel.com "delete automatically" wrote: how do I delete a row automatically after each date is over |
how do I delete a row automatically after each date
Galimi.
What you explined to me works great, it took me a while to do it but it;s working great. Thanks a million "delete automatically" wrote: here is an example A B C 1 12/20/06 Bill 6am to 2pm Tom 2pm to 10 pm 2 12/21/06 Dan 6am to 2pm carl 2pm to 10 pm 3 12/20/06 Bill 6am to 2pm Tom 2pm to 10 pm 4 12/21/06 Dan 6am to 2pm carl 2pm to 10 pm when 12/20 is over I want row 1 to be deleted Sorry about being a pain but thanks for your help "galimi" wrote: I've corrected the code and put it at http://HelpExcel.com/examples It's named autoDelete.xls This will delete the entire row. -- http://HelpExcel.com 516-984-0252 "delete automatically" wrote: Galmini, were almost there, I have the dates in column A row 1 I also have other stuff in columns 2 thru 10. The date in column 1 delets but everything to the right stays there. What I'm looking for is to delete the whole row when that date ends. Thanks for your patients "galimi" wrote: Correct. Try entering a date prior to today. You will notice that the entire row will delete automatically. -- http://HelpExcel.com "delete automatically" wrote: So, are saying , everything in that row will be deleted after that date? "galimi" wrote: I have copied an example to http://HelpExcel.com/examples -- http://HelpExcel.com "delete automatically" wrote: Where do I copy it too? Thanks for your help "galimi" wrote: You can embed code similar to the following on an selection change event for the sheet For Each cl In ActiveSheet.UsedRange.Cells If cl.Value < Now Then ActiveSheet.Rows(cl.Row).Delete End If Next -- http://HelpExcel.com "delete automatically" wrote: how do I delete a row automatically after each date is over |
how do I delete a row automatically after each date
Galimi,
I had it working until I lost the formula you gave me. It was the one you sent me in reply 2 something like ()+1. could you please send it again, I must have deleted it thanks again "galimi" wrote: I've corrected the code and put it at http://HelpExcel.com/examples It's named autoDelete.xls This will delete the entire row. -- http://HelpExcel.com 516-984-0252 "delete automatically" wrote: Galmini, were almost there, I have the dates in column A row 1 I also have other stuff in columns 2 thru 10. The date in column 1 delets but everything to the right stays there. What I'm looking for is to delete the whole row when that date ends. Thanks for your patients "galimi" wrote: Correct. Try entering a date prior to today. You will notice that the entire row will delete automatically. -- http://HelpExcel.com "delete automatically" wrote: So, are saying , everything in that row will be deleted after that date? "galimi" wrote: I have copied an example to http://HelpExcel.com/examples -- http://HelpExcel.com "delete automatically" wrote: Where do I copy it too? Thanks for your help "galimi" wrote: You can embed code similar to the following on an selection change event for the sheet For Each cl In ActiveSheet.UsedRange.Cells If cl.Value < Now Then ActiveSheet.Rows(cl.Row).Delete End If Next -- http://HelpExcel.com "delete automatically" wrote: how do I delete a row automatically after each date is over |
| All times are GMT +1. The time now is 11:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com