Hi
Now I think I understand what you are trying to do. However MS Project is designed to manage progress against a pre-determined timescale for each task. Whilst there is a "manual" way doing what you want in MS Project I dont see any value in it. You are using Excel in this way which is a far better way of achieving what you want do do.
In Excel to pick up the last value in a row I would use the following formula:
=LOOKUP(9.99999E+307,H2:P2,H2:P2)
This will only display the last value in the row H2 to P2. The range can be changed to suit what you need.
Hope this helps.

Good luck.
Tony (OTPM)

Hi Tony,

Thank you for your note. I truly appreciate your response. Just to clarify, I am not aware as to how the value will be populated in the last column, but still would there be a way to solve my issue and have the "daily data overall" column populate automatically(based on the value in the last cell)?

Any help would be grateful.

Regards.

Hi
If you use the formula provided above in Excel the "Daily Data Overall" column then this will automatically pick up the last value entered in each row.
Hope this helps.
Tony (OTPM)

Hi Tony,

So would =LOOKUP(900000000000,'Sheet 1'!N1:Z1) solve my problem?
But what should I mention as column N and Z?

Regards.