Auto filling a cell with data from a different sheet based on Today()

Ok, I'll try to explain this a little better.

I have two worksheets; "December" and "Backlog". In cell Q6 of "December" there is a value that changes throughout the day based on information I insert/remove from a table. On the "Backlog" worksheet, I have another table that is simply two columns: "date" and "backlog hours".

I am wanting to auto populate the "backlog hours" cells by date. For example, say "date" is column A and "backlog hours" is column B. A1=12/10/14 A2=12/11/14 etc. I would like B1 to keep the last value entered in cell Q6 of that day. Then it would move down to the next date and change throughout that day and save at the end.

I tried an IF formula, but can't get around the value changing back to 0/FALSE when the "date" cell no longer matches today().

Any help would be greatly appreciated.

Thanks

I tried what I believe your code should read and it seems close. I keep getting a #VALUE error though. I've attached a file that should contain all of the info needed. Let me know what you think.

The way you worded it makes sense, it just seems like the loop is confusing the formula?!

Many thanks,

test backlog.xlsm

Ha! Missed that... not sure where the R11 came from. I must have accidentally clicked that cell and kept reading over it. That seems to function well for now. Like you mentioned above, it only seems evaluate this once, so the first time I open the file, it will update to the current info in Q6, however it does not continually update as the data in Q6 changes.

The formula I am now using is =IF(B2=0,IF(A2=$C$1,December!$Q$6,B2),B2). If I manually change the date in C1, the corresponding B cell will input the data from Q6. However if I then change the number in Q6 it does not update to the B cell. This is acceptable, however, it would be nice to continuously update as long as A#=C1. Is that a possibility?

Again, many thanks!

Thank you.

So, after all of that, I forgot to save my file. I went back through and re-added the formula and the code as well as updated the iterative calculations setting. Everything is functioning the same with exception to the auto update... It will not update on its own as Q6 is changed. If I double click on the corresponding B# cell and then hit enter, it will update. What could I have missed?

Sorry and thanks...

Yes, I had copied it directly from your post... I just deleted it, copy and pasted again and now everything is working...

I, again, must have missed something. It is now saved

Thank you.