Hi folks, I am running Excel 2007.

I have a small table that gets generated based on up to 10 Point1 to
Point2 cells.

The table calculates distance from 1 to 2 (and some other sundry data
as well in subsequent columns)

Problem is that if I'm only going to Point6 I'm left with 4 more rows
of data. The Point6-Point7 row has 6 as a Column A start point but a
Zero in Column B as an end point.

This table is just a stepping-stone before all of this data makes its
way to the Sheet that will be printed. How might I go about copying
ONLY the rows in which Column B does not display Zero, whilst making
it possible to copy them all should the next generated set of points
use all 10? Or just 2?

The range I am working with is A30:T39

Many thanks!
Craig