Copy above row data into blank fields below

F

FamilyGuy902

Hi. Certain fields within my data do not repeat, but I'm trying to
find a way to populate the blank cells from the preceding row. Here's
an example:

Employee_Number Last_Name First_Name
123456 Smith John
Judy
Ben

123457 Johnson Bill
Ruth
Eddy
Sally

As you can see, it didn't repeat the Employee Number or the Last Name,
for the spouse, and children, because it is the same. Is there a way
to write a function or macro to populate the missing information?

Thanks,
Jason
 
F

FamilyGuy902

Thanks very much!!!!!!!!!!!!!!!!! it worked like a charm! I've been
scratching my head for months trying to figure this out!

Jason
 
Top