Hi experts,
You've been very helpful in the past, so I figured I'd ask you for help again!
I have a database with columns split into days and weeks for the year, and rows representing jobs / orders.
Cells will then be populated with relevant data for the various jobs / orders in a given day.
The problem is that 5-6 months into the year, the file starts to get very large - and as such, slow to work with.
I was therefore hoping to make a macro where the user can remove/allocate "old" data - i.e. data that is older than, say, two weeks from today - to a separate file, where it can be archived. (That way the user can always jump into the archive-file, should they feel the need to backtrack something).
.. here's the trick though! It needs to only remove rows when a cell meets a specific criteria that indicates that the job/order is no longer "alive".
I have very little experience with VBA, and any suggestions and help you may be able to provide will be much appreciated!
//Jbm
You've been very helpful in the past, so I figured I'd ask you for help again!
I have a database with columns split into days and weeks for the year, and rows representing jobs / orders.
Cells will then be populated with relevant data for the various jobs / orders in a given day.
The problem is that 5-6 months into the year, the file starts to get very large - and as such, slow to work with.
I was therefore hoping to make a macro where the user can remove/allocate "old" data - i.e. data that is older than, say, two weeks from today - to a separate file, where it can be archived. (That way the user can always jump into the archive-file, should they feel the need to backtrack something).
.. here's the trick though! It needs to only remove rows when a cell meets a specific criteria that indicates that the job/order is no longer "alive".
I have very little experience with VBA, and any suggestions and help you may be able to provide will be much appreciated!
//Jbm