Data trapping
 

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

Data trapping
 

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

Data trapping
 

VERY limited. Such as using the Find( ) function to see if a particular
value is present in a cell.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Flipper" wrote:

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

Data trapping
 

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 Brown" wrote:

VERY limited. Such as using the Find( ) function to see if a particular
value is present in a cell.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Flipper" wrote:

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

Data trapping
 

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

Data trapping
 

Flipper wrote:
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.


Not sure what you are trying to do. Define "trap" without using the word
"trap". Maybe show some data and the results you desire.