Thank you very much for your help. I totally understand what you mean about merging cells as I have already run into an issue!

I am trying to populate the cells depending on the weekly/montly as well and am getting stuck. If weekly I want the range of cells to show 6 and of monthly I want the 1 to show 20. I have uploaded my sheet for you to look at if you /anyone can help me!

Thank you!

ChrisThrowdown.xls