Hi guys,

I really need your help! I am making a new system for my Window Cleaning business and I have attached a list of customers that I am cleaning windows for. I am doing this every other week, which is why the calendar at the top of the page looks how it does.

However, on the right hand side, I have a list of the weeks (26 in total) with a "Houses Cleaned" column and a "Total" column. I would like the two figures at the bottom of the page to go into the correct cells.

If that didn't make sense, say if I was cleaning windows on the 04/01/2016 and I cleaned 40 houses and made £152.00. I would like these two figures to go into that row on the right hand side. I have actually figured out how to do that but when I change the date, the figures change and it just goes on to the date which is selected.

Therefore, if possible, I would like the figures for 04/01/2016 to stay in their specific cells even if another date is selected. Therefore, come the end of the year, I would like the table on the right to be filled with figures automatically. If this is possible, I would really appreciate it if someone could help me.

I will attach the file below. Just to make it clear, I would like the "40" and "£152.00" to stay in each of the boxes when the user changes the dates.

Many thanks, FFFLeague15

Trial.xlsm