VBA coding require for auto fill maximum location in blank cells

Hello Everyone,

I have data in range C1:D30, in which column c contains customer details and in column D location. I have require a code to fill the blank cells with the maximum used location in the range.

For Example:- if I filter for Cus 1 in customer detail then blank cells should be filled by the maximum repeated location which is appearing in filtered range.

Thanks in advance
Anil Kumar