great answer
Posts by adilucb
-
-
Selecting rows by date for 14 day periods
I have data from a calendar in my excel spreadsheet, I want to be able to select any date located in the first Column A, and then run a macro which will find the date 2 weeks ahead, copy the data in between and paste in a new sheet or new file.
The problem is the date 2 weeks ahead must be a weekday, becasue weekend and holiday info is missing. If the date 14 days ahead is missing I want the macro to go to the previous day and try to find it, if it is also missing then go back 1 more day...until it find a date which is actually in the calendar data.
Thanks for the help, i appreciate it!
-
Re: Dates: Selecting rows based on 2 week intervals
Column A contains all the dates, the other 4 columns contain info, anmd I am looking to select and copy 2 weeks (14 days) forward from the activecell selected, any date that is selected when the macro is started.
-
Re: Deleting rows with criteria met
How can I modify this code to delete certain rows based on the date which is in the cells. I need to delete all other rows except the ones contained in a 2 week interval following the date in the activecell.
So basically after i select a certain row which contains a date, I want teh program to find the date 2 weeks ahead(14 days) select and keep all that data an delete the rest of the rows. Catch is if the date 2 weeks ahead is a weekend date then the macro should go back 1 day at a time until the date of the friday is found in the Column A being checked. Thanks for the help.
-
Re: Dates: Selecting rows based on 2 week intervals
LET ME CLARIFY:
I have data from a calendar in my excel spreadsheet, I want to be able to select any date located in the first Column A, and then run a macro which will find the date 2 weeks ahead, copy the data in between and paste in a new sheet or new file.The problem is the date 2 weeks ahead must be a weekday, becasue weekend and holiday info is missing. If the date 14 days ahead is missing I want the macro to go to the previous day and try to find it, if it is also missing then go back 1 more day...until it find a date which is actually in the calendar data.
Thanks for the help, i appreciate it!
-
Hello need help setting up a macro which will look 2 weeks forward down a column and select the data between the activecell and 2 weeks ahead.
The catch is the date 2 weeks ahead cannot be on a weekend, if it is then the macro should go back 1 day, and go back another day until it find a date. Once this 2 week interval is selected the macro should copy the info, and paste it in a new sheet. PLEASE HELP ME WITH THIS CODE