One more question. Is there a way to revise B3 in Dashboard to change to 0
the first time the workbook is opened any given day?

I am thinking something like if the cell associated to the date in 'Draw' is
empty, make B3 = 0. Then once B3 is changed it will insert a value in the
associated date in 'Draw' from your previous macro preventing B3 from
changing to 0 again that day.

Would that work?

"Sheeloo" wrote:

You are most welcome.

That is what computers are meant for.... saving us from tedious work.

"SPISO" wrote:

Thanks So Much. It worked. What a time saver.