Thanks for the quick response but it does not help. i should have been more
specific. In monarch, you are able to trap report headings and column
headings which allow you to "trap" only certain and it filters data that
repeats itself such as page numbers, titles, etc.
--
Allan


"Gary''s Student" wrote:

In some sense.

It is possible to detect when a cell achieves a certain value, either
thruough manual input or via calculation, and to take action when the event
occurs.

These are Worksheet Event macros. See:


http://www.mvps.org/dmcritchie/excel/event.htm

--
Gary''s Student - gsnu200800


"Flipper" wrote:

CAn Excel be used to trap data in a similar fashion to Monarch?
--
Allan