| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I delete a row automatically after each date
how do I delete a row automatically after each date is over
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically filling date of today (without it changing tomorrow) | Excel Discussion (Misc queries) | |||
| In Excel why does the date I enter automatically change by 1 day? | Excel Worksheet Functions | |||
| date of monday of each week automatically | Excel Discussion (Misc queries) | |||
| Excel to automatically enter a date | Excel Worksheet Functions | |||
| Automatically enter today's date as a static entry | Excel Worksheet Functions | |||
Linear Mode
