Posts by adilucb

great answer

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