Problem building automatic progress report updater

Dear all,

As the title says, I'm having troubles building a macro which updates the progress of a current project.
I've got a sheet with a waterfall-like detailed planning of the project, which shows the progress (in %) of the project streams.

What I'm building is a function to take this progress percentage (updates per day) and copy it in another table (different sheet) which is linked to a chart, graphically showing the progress.
The copying part is all alright and I can perform the macro with a button, but now my problem is that it is not copying & pasting the right progress made in terms of the date.
What I need, in short, is to upgrade my macro to copy the progress percentage and paste it in the cell resembling the correct date (= today).

This is my current code:

Please Login or Register  to view this content.

I know the code is very 'unwieldy', but up to now it did the trick (see the warning added in the button click event), since I am a VBA dummy.
By the way, due to confidentiality the code/file is a mock version.
Can you guys help me to upgrade the macro? Please regard the file for a simple version of the problem: MacroForHelp.xlsm

Cheers,
Lennart

PS: is it possible to update the progress chart without opening the excel/clicking the button? So updating happens 'under the water'?
PPS: If you forget to update the progress chart daily and for example update 4 days later, is it possible to include the missed days in the macro (which would be prevented if PS works out)

maybe something like this

Please Login or Register  to view this content.

Thanks for the reply, nilem.
I've implemented it in my mock sheet, and it works perfectly there. However, in my real sheet it doesn't, maybe because I don't entirely understand the code.
What does the 'dt +3 part' mean, for example? I think I have to change that part as well.
Additionally, starting the 'With' with stating the sheet, does that mean you select/activate it? My macro button is on another sheet and the macro copied content on this sheet...

Thanks in advance!

Excuses, double post

'dt' is the difference in days between now and the start date (20 in this case). 'dt + 3' (ie, 23) is the column number with today's date.
'With Sheets("Sheet1")' means a reference to the Sheet1, the Sheet1 is not activated.
And oops, I forgot "." before Cells (I always forget them)

Please Login or Register  to view this content.

Alright, that makes it more clear.
In other words, it account for the three columns between the start of the workbook and the first date.
I got it to work now, hope it still does when I'll update it tomorrow .
Thanks for the help anyway, if needed I'll post again.

Cheers!

Guys, nilem,

The update as-is works like a gem, thanks!
Now, there is another little tweak I'd like to implement: say, you forget to update the table for 5 days. In the current situation, when you hit the update button you'll add only the status as of the day of updating. Would it be possible to include the progress made in the previous days (so, those days when you forgot to update) when updating?
I'd like to hear from you!