VBA assistance - Dim monthFound As Range (For multiple cells)

[philwilliams80]

Hello,

I have what should be a very simple query for someone with a bit more VBA knowledge than me. I've had a good go at trying to fix the problem myself, and have got 99% of the finished product, but just need a final push over the line.

I have a sickness database which is automatically populated from a template sheet when the macro is run, but at present it pulls a number of days and puts them all into the corresponding month regardless of whether the month rolls into the next one. Eg 61 days all in the April column rather than 30 days in April and 31 days in May.

It took a while, and it's probably a very long-winded work around, but I have managed to get a formula to produce the number of working days for each month into the template rather than the number of days in total.

So what I need is for instead of the macro to pull across a total number of days from one cell to either Apr, May, Jun etc for the correct person, I need it to pull across the range of 12 cells into the 12 months, but making sure it still adds the days onto any that may already be there, and doesn't paste over the top.

In short, before tinkering the macro pulled D21 (on the Template sheet) into the database depending on name and start date.
Now I want it to pull I21:T21 into the database for the correct person.

I've attached the Template and Database for anyone willing to have a look.

Many thanks,
Phil