Archive anything older than 90 days and if actioned = Yes

Hello,

Was reading up on this and i'm thinking of merging but the i saw something about advanced filters and thought i'de turn to the boards!

Corporate Action History Master.xlsx

What i was hoping was that automatically when "Response deadline date" [G] is past todays date by 90 and "Actioned" [H] = "Yes" that the entire row be cut across to Archive.

If had some success finding code to "Archive" based on a text value ("YES") but nothing on date/time...

Any thoughts please?

Links to any known threads also welcome please

Hi

this may get you going

Please Login or Register  to view this content.

rylo

hmmm

Run-time error '13'
Type mismatch

Hi

How about updating your example file to show a data sheet with some representative data so we can see what you are working with.

rylo

Corporate Action History Master.xlsx

Rylo updated as suggested

thanks for helping

Hi

I changed the 2 to 7 in the first line of the code to match your data situation, and the code ran for me with no errors in the example file from #5

Please Login or Register  to view this content.

Try that and see how it goes.

rylo

Works great in my example thankyou!

still getting that error in my Master Spreadsheet, so i think im just going to make a new one

thanks again reped

For future reference for anybody

Run-time error '13'
Type mismatch

This occured when there were blanks within the "Date" column

Any thoughts please on how to skip blanks?

I had a crack and failed!

Please Login or Register  to view this content.

Hi

How about adding an example file that exactly matches your real situation (some blanks, some filled etc). That way we have something concrete to work on.

rylo

Hi -

Another thing to look at in Type mismatch error is if the date column is not actually a date value.

So, add another test if isdate

Regards,
event