Please I have a table on Tab 'Log' which lists details of non functional assets entered daily.
on Col R I want to change the entry on the dropdown list to 'Closed' for all rows with the same number on Col C
For example For Rows 6 entered on Col C , entries in cells on Col R should change to Closed
Please help !!