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.