script to find a line in excel

[Sydpark]

Hello,

I am new to VB and am struggling with an issue.

I have a spreadsheet that has many rows that are related to a specific row above them.

ie

top row has a summary, following rows have details related to the row above (different number of lines each time).

I want to take two cells (E & F) out of the summary row and attach them to all of the detail rows below until it hits another summary row and then delete the summary line.

the end result should be no summary lines only detail lines with columns (E & F) populated with the data from the Summary (E & F) row.

The summary line is designated in column A as "HDR".

I have been looking at the find function as well as the if statement but cannot seem to tie them together in a satisfactory way

I hope I have included enough detail and that more importantly there is someone out there who can point me in the right direction.

Thanks in advance
sydpark

[Crzyrio]

If you could give us a visual example of the data that would be very helpful!

[Sydpark]

If you could give us a visual example of the data that would be very helpful!

HDR SI 493987 53009014 14/05/2013 JN7563/ 14047626
ITM 14670 water 53005499 0 EA
ITM 14627 earth 53005499 0 EA
HDR SI 493987 53029083 15/05/2013 321 PITT ST--DUNCAN
ITM 123140 wind 53020327 0 EA
ITM 10 fire 53020327 0 EA


I have included a sample above. The real spreadsheet has many lines in between and multiple occurrences. I tried attaching the file but it would not take xls or csv

Thank you so much for taking the time to look at it.

Regards,
Sydpark