A deadline beckons, and help with regard to the following would be greatly
appreciated.

I have an eight-column Excel (for Mac, but don't think that matters) sheet
(columns "A" -"H") and am trying to write a macro that will look down the cells
in Column "H" (about 10,000 rows of data) and upon finding an empty cell, copy
the contents (text) from the cell directly above it IF:

--the "target" cell is empty; AND
--the value of the corresponding cells over in column "D" equal each other.

In other words, IF:

in Column "D" Rows 26 and 27 both have a value of, e.g., "Smith"; AND
in Column "H", Row 26 has a value of "Judge12", and Row 27 is empty,
the macro should copy "Judge 12" from Row 26 to Row 27 in Column "H"


Steven Rosenberg : )