Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data trapping
CAn Excel be used to trap data in a similar fashion to Monarch?
-- Allan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Trapping | Excel Discussion (Misc queries) | |||
Trapping #VALUE! error | Excel Discussion (Misc queries) | |||
trapping charts event | Charts and Charting in Excel | |||
Error Trapping from WSH | Excel Discussion (Misc queries) | |||
error trapping | Excel Discussion (Misc queries) |