Max,
A strange thing happened and I am puzzled now.
When I saved the workbook with a different name, the formuls are returning
null values for each day in the summary sheet.
What went wrong here???
"Max" wrote:

You're welcome !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Firebird" wrote in message
...
Thanks for your response. I also used the VALUE(LD_YEAR) to refrence YEAR
selected from Combo Box and it worked.
But I will copy the values for YEAR_TABLE as you suggested.
You have been a great help.