I have a 2 worksheets. Worksheet 1 gets data from an external source
and refreshes every 10 minutes.

Worksheet 2 extracts data from sheet 1 using formulas. When a countif
formula returns a value of lets say 200 I want a e-mail sending to
me .

As a novice user any suggstions welcome.