Hi,

I need help with this,

I have got the first quarter working and a mild attempt at the other 3 but the code is in there and all works, they all work individually just need to revisit the code to make it work wherever you click in the screen. You will be able to see my attempt in the Ifs in VBA.

I can not get this to work. I need it to show for "All" the sites as well.

The vba basically passes the variables into row 6 on the Change Calendar and you can see what I have done on the change impact calculator sheet.

Change Calendar (3) (3).xlsm

Thanks,

Nic