I need a simple macro to add the Donor's name to multiple donations

The actual database is about 10,000 lines, so the macro I envision would check to see if there's date in the Date column, and if True, copy the Account Name to the line below. if there's no date, then it drops down a line (or lines) until it finds the next Account Name with multiple donations.