Hi there,
I would be grateful if anyone could possibly help?
I currently have one sheet on excel where certain action points are kept for review. After 5 years, these action points no longer need to be reviewed and I want to insert a macro /VBA where the whole row of data will automatically archive to the separate "archive" sheet after the implementation date has passed 5 years.
The actions also need to be 5 years by year only, not exactly 5 years (1825 days) from today's date. For example, as it is 2018, I need to keep data for 2013, 2014, 2015, 2016, 2017 and 2018. Once the 2019 year begins, I would like all of the action points from 2013, and related data on the row, to automatically archive to the "archive" sheet. This will leave me with data of action points from 2014 - 2019 (5 year period). I would like this to be in place to ensure that staff do not carry on conducting time consuming reviews on data which is over the required 5 year time frame.
I am having issues with creating a VBA to auto archive anything date related, but especially year only related. Most of the examples I have seen are a certain time frame in days from today's date, which is not what I require. I want to archive any rows which contain a date (under the date of implementation category) which is over 5 years from the current year.
I would really appreciate any assistance with the above
Many thanks
I would be grateful if anyone could possibly help?
I currently have one sheet on excel where certain action points are kept for review. After 5 years, these action points no longer need to be reviewed and I want to insert a macro /VBA where the whole row of data will automatically archive to the separate "archive" sheet after the implementation date has passed 5 years.
The actions also need to be 5 years by year only, not exactly 5 years (1825 days) from today's date. For example, as it is 2018, I need to keep data for 2013, 2014, 2015, 2016, 2017 and 2018. Once the 2019 year begins, I would like all of the action points from 2013, and related data on the row, to automatically archive to the "archive" sheet. This will leave me with data of action points from 2014 - 2019 (5 year period). I would like this to be in place to ensure that staff do not carry on conducting time consuming reviews on data which is over the required 5 year time frame.
I am having issues with creating a VBA to auto archive anything date related, but especially year only related. Most of the examples I have seen are a certain time frame in days from today's date, which is not what I require. I want to archive any rows which contain a date (under the date of implementation category) which is over 5 years from the current year.
I would really appreciate any assistance with the above
Many thanks
