Excel VBA: Select range of data and plot chart

[xitu]

I have this sample excel spreadsheet:

http://viet.ws/chart.xls

The original columns are "Time", "Pressure" and "Diff. Pressure".

I would like to build a macro to do the following things:

- Mark "HP-Start" if the max Pressure is found (within HP range) and mark "HP-End" when it reaches the last "HP" cell in this block.

- Set counter = 0:00:00 in column "Time" and the increment is 3.
- Set counter = 0 in column "Diff. Pressure" but the next cell will a calculation (the formula is shown in the above excel worksheet)

- Finally, plot column "Time" and column "Diff. Pressure"

Note: This sample is one of blocks I have in my Excel. How do I write a macro to loop the whole worksheet?
Please help.

Thanks,
XT

 

[ETID]

WITHOUT USING VBA?
IN CELL F15


=IF(AND(B16<11300,D16=&quot;&quot;,D15=&quot;HP&quot,&quot;HP-END&quot;,&quot;&quot


FILL UP OR DOWN

 

[ETID]

Oooops ... I answered the question in the cell, rather than your post....stay tuned

 

[xitu]

I am still working on this... Does anyone have any idea? I need your help.

Thanks,
XT