Data trapping

[Flipper]

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

 

[Gary''s Student]

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 Brown]

VERY limited. Such as using the Find( ) function to see if a particular
value is present in a cell.

 

[Flipper]

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.

 

[Flipper]

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.

 

[Glenn]

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.