| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automaticall e-mail me when cell value reaches a value
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automaticall e-mail me when cell value reaches a value
This will need some code writing in VBA.
Is there a MS usergroup for VBA? As you are a novice user, you will have to get this written for you. (I would too)....but I've seen exactly this sort of thing done on a Share Price monitor which was refreshed every minute! Paul " wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automaticall e-mail me when cell value reaches a value
You can try this
See this page http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automaticall pick up info from a cell from a shet t oanither sheet , in the same cell, same book | Excel Worksheet Functions | |||
| Is there a way to make a time cell not reset when it reaches 24? | Excel Discussion (Misc queries) | |||
| Highlight Cell when value reaches every interval of 500 | Excel Discussion (Misc queries) | |||
| execute external program when cell reaches certain value | Excel Worksheet Functions | |||
| HELP ME !! PLEASE!! How do I highlight a cell when it reaches a va | Excel Worksheet Functions | |||
Linear Mode
