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
Bookmarks