I am currently gathering data in an excel spreadsheet by means of a msquery. I have created code to run an update via vba code. Thanks to your help! As each value that is updated in the spreadsheet, it is used in a formula to evaluate changes. Each time this change meets the alarm criteria, I need to log it in a file for further review. I know that I can create an if-then statement in VBA, but how do I get it to log or print on to another file(sheet) for further review, in order of occurance, keeping each time an alarm condition occurs?
Any help is always appreciated.
thanks,
Gabbie