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

Record a macro that dows your stuff and change it as you will.
Peace