Copy row based on criteria

[rct2323]

I am trying to copy an entire row that starts with the word "HDR" in the cell to all the rows below it that start with "DTL" until it reaches another row that starts with "HDR". Once it reaches another row that starts with "HDR" it will copy the row "HDR" to all the rows below it that start with "DTL" till it reaches a row that starts with "HDR" again.

For example if C1 is "HDR123", C2 is "DTL123", C3 is "DTL345" and C4 is "HDR456" it would copy row C1 to B2 and B3. I would then copy C4 to whatever rows below it start with "DTL". Any help would be greatly appreciated.
Thanks,

[rylo]

Hi

How about

Please Login or Register  to view this content.

rylo