Update absence tracker so that absence is automatically moved between sheets

Hello.

I use the below code for my absence tracker which was kindly provided on another forum.

I now need to change it, so instead of looking at current 12 month rolling period and previous 12 month rolling period, it looks at:

Current 6 months Tab - All absence in the last 6 month rolling period from the current day (based on absence start date)
Previous 6 months Tab - All absence from between 6 and 12 months from the current day (based on absence start date)
Previous 12 months Tab - All absence between 12 months and 24 months (based on absence start date) and delete all rows containing absence older than 24 months from current day.

In essence, basically splitting "current 12 months" in half into "current 6 months" and "previous 6 months".

When the workbook is opened, it automatically moves each absence row between the tabs depending on the absence start date.

The names and order of the columns will remain the same.

Hope this makes sense. Original code is below:

Please Login or Register  to view this content.

Unfortunately, uploading of the example file failed.

Originally Posted by Chris_M_1987

Unfortunately, uploading of the example file failed.

Did you get an error indicating why it failed? Usually this is because it is too big.

There is a size limit of 1MB for Excel files but you can zip the file. The limit for .zip files is 9.77MB.

Hello,

The .xlsm file is about 3.5mb, i just got a message saying the upload failed. I didn't see any other message but I can now see there's an upload limit. Let me see if I can upload a ZIP.

Also, the title of this thread seems to have changed. Not sure what's happening.

Kind Regards

Originally Posted by Chris_M_1987

Also, the title of this thread seems to have changed. Not sure what's happening.

You will note in the comment at the bottom of your first post that I changed the title. Your original title of VBA Code Help was not descriptive of your question; every question in this subforum is asking for VBA code help. A title should give enough information so that members can determine from the title if it is something they will be able to help with, and be useful in a search. Because it is your first post I changed it for you rather than issuing a violation notice.



Administrative Note:

Welcome to the forum.

Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles.