Get The Values to Stick and Stay

[fffleague15]

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.

Many thanks, FFFLeague15

Attachment 432705

[sktneer]

Unfortunately this is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...-and-stay.html