I have this table where i have to populate the '0' values from above values. I tried using the above() but it seems it works only one time. For example if have a value on first row and the below 2 rows are empty then the second row gets filled by above() but not the third. I am using three other list boxes namely Year, Type and PC Name as a filter to get to the values shown in the attachment. So, can anyone help me how i can populate the other rows??