Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format Excel column to notify with a reminder
Hello,
I have a mailing log in an Excel sheet. There are particular ocassions that need second copies mailed. I would like to be able to format my "sites" column to notify me with a reminder whenever I enter one of the particular "sites" that need the additional copies to be mailed. Can this be done? Using Excel 2000 Thanks Linda |
#2
|
|||
|
|||
Dear Sir, There is several ways to accomplish that. Proably the easiest is as follow: 1. Create a table with the names of all the sites for which you want alerts. 2. Make a name range for the entire table. 3. Add an additional column to your original table an name it alerts. 4. In that new column Use a VLOOKUP function to verify each new site you enter. 5. The vertical lookup can place a mark or message in the new column If you need it additional help let me know. Regards Juan Carlos -- cscorp ------------------------------------------------------------------------ cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015 View this thread: http://www.excelforum.com/showthread...hreadid=375964 |
#3
|
|||
|
|||
In a previous posting I found exactly what I need except for one problem and
I really know nothing of writing codes. On 3 14-05 Jason Morin replied to a post from red_oceanus on this same matter. The code he presented pertains to the first column. I need the message to work in the fourth column only. When I use his code I recieve a pop up message in any of the first four columns instead of only the fourth column. How can I edit this code to suit my needs? Jason's response follows: Assuming data entry cells are col. A, right-click the worksheet tab, choose "View Code", copy in the code below, and press ALT+Q to close VBE. Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim sMsg As String With Target If .Column 1 Then Exit Sub If .Count 1 Then Exit Sub Application.ScreenUpdating = False Select Case LCase(.Value) Case "new instrument" sMsg = "Call Propertry Accounting" Case "new house" sMsg = "Call Inspector" Case "new car" sMsg = "Buy Insurance" Case "robbed" sMsg = "Buy Gun" 'additional messages here Case Else sMsg = "Don't Recognize This" End Select MsgBox sMsg Application.ScreenUpdating = True End With End Sub "cscorp" wrote: Dear Sir, There is several ways to accomplish that. Proably the easiest is as follow: 1. Create a table with the names of all the sites for which you want alerts. 2. Make a name range for the entire table. 3. Add an additional column to your original table an name it alerts. 4. In that new column Use a VLOOKUP function to verify each new site you enter. 5. The vertical lookup can place a mark or message in the new column If you need it additional help let me know. Regards Juan Carlos -- cscorp ------------------------------------------------------------------------ cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015 View this thread: http://www.excelforum.com/showthread...hreadid=375964 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Format Excel Sheet ToShowRowNumbers but not the column alph | Excel Discussion (Misc queries) | |||
Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |