Hi excelentuser,
I found this code at http://www.mvps.org/dmcritchie/excel/fillempt.htm that might do what you're looking for. I combined three pieces of code:
1. The code that fills empty cells with the text in the cell above it
2. The code to sort the selection by the name column (column A)
3. The code to remove those duplicate text entries created in step 1.
Prior to running the code you must select your range of data, e.g. A1:C47. Put this code in the worksheet's code module by right-clicking on the sheet tab and selecting View Code. You can then run the code by pressing ALT+F8 and selecting 'Sheet1.FillEmpty' from the list and clicking Run.
Let us know how that works for you.
Bookmarks