Populate Blank cells across rows for a given unique name range.

[mathkw]

I have a large spreadsheet with many columns. Column A contains a list of names under a header called "Borrowers". The values in this column are alphabetized and there are duplicate names. For each unique list of names in column A, I need to look across the rows. If a cell is populated let's say in column B for the given unique name range, I need a script that will populate the empty cells above and below the populated cell within a unique name range with the value from the populated cell and in that unique name range and then shade the cell in a color to indicate that it is newly added data to that cell. I need this logic to work across every column in my large workbook.

In the attached sample, I show the Before and After for what I am looking for. And notice that in the after shot, there remains blank cells in the Loan Purpose column for Abbits, Anna. I would not want those blank cells populated because for that unique range, I don't have a single unique value in the populated cells. One cell for that unique range has Purchase and the other has Sales.

Thank you

Kevin