Copy cell entry down and repeat until complete

Hi there,

First post here so please be gentle

I have manage to create a macro albeit recorded to format the report into a Pivot friendly format.. I have now hit a snag and wondered if anyone could shed some light on how to program a macro to copy the skillset to the empty cells below and loop until all skillsets have been copied.

For example column A
A1 = Skillset
A2 = EM_01
A3 = BLANK
A4 = BLANK
A5 = BLANK
A6 = EM_02

Where the BLANK's are they would now show EM_01 and then it would repeat the copy for A6 = EM_02.

Any help would be much appreciated.

Cheers

Try this and let me know if works

Please Login or Register  to view this content.

Thanks fredlo2010. Worked a treat!