I want to copy partial row to blank row(s) beneath it

[BWestly]

I have a worksheet where each item may be over 2 or more rows but the first
part of the row is blank on rows 2 and up. I need the 1 row information
copied to the other rows that pertain to that item so I can sort properly.

[CLR]

ASAP Utilities, available free at www.asap-utilities.com, has a feature
called "Copy values to empty cells below filled cells in selection".

hth
Vaya con Dios,
Chuck, CABGx3



"BWestly" wrote:

> I have a worksheet where each item may be over 2 or more rows but the first
> part of the row is blank on rows 2 and up. I need the 1 row information
> copied to the other rows that pertain to that item so I can sort properly.