visual basic for applications

Hello, I have a chart named "VelChart". It fetches data from a set of dynamically created cell values. However, I want the chart to be cleared of any graph every time I said referenced cell values are refreshed. I have this code that isn't working: Worksheets("Velocity...

Hello, I use the below code for my absence tracker which was kindly provided on here. 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...

Hello, @Petertenthije kindly provided the below code for my absence tracker on 13 August 2022. On the "current 12 months" tab, is held all absences within the current 12 month rolling period. The code will then activate upon opening the workbook and move any rows with an absence start date of...