Simple loop macro needed

[Gillman]

Hi there

I need a simple loop macro which will run down column A and each time is finds a name there, it copies the name down to each row until it reaches the next name and then copies that name down all the blanks etc.

I know this is probably simple to do. I'd really appreciate any help with this.

Cheers,
Darren