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
Dave Peterson - 27 Sep 2006 21:20 GMT
Check out Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html
> 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
[quoted text clipped - 16 lines]
> Thanks,
> Jason

Signature
Dave Peterson
FamilyGuy902 - 27 Sep 2006 21:34 GMT
Thanks very much!!!!!!!!!!!!!!!!! it worked like a charm! I've been
scratching my head for months trying to figure this out!
Jason
> Check out Debra Dalgleish's site:
> http://contextures.com/xlDataEntry02.html
[quoted text clipped - 19 lines]
> > Thanks,
> > Jason