Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generate letter
Good grief what is the world coming to?
A world where corporations are subject to self-regulation (that is they can pollute and/or exploit at will), but parents of absent kids get a letter. Talk about picking on the easy targets. Bob "dvya" wrote in message ... I am using a excelsheet to track attendence at my preschool. I have a table, the first column is a list of 200 names, the next 20 columns are all the school days of the particular month. For each school day i have a letter code i.e. a=absent p=present. Every time a child is absent i have to track the reason, is the child sick? did they go on vacation? etc.. What i would like to do is to have excel automatically generate a letter that I can sent to the parents if the attendence code is "a"(absent). In my limited knoledge of excel i figured that the best way to do this is , to bring forward to another sheet every instance where "a" is used along wth the childs name and date of absence, and then run a mail merge on this sheet. Is this the best way? What formula would i use to do this? Thank You. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generate letter
???
In article , "Bob Phillips" wrote: Good grief what is the world coming to? A world where corporations are subject to self-regulation (that is they can pollute and/or exploit at will), but parents of absent kids get a letter. Talk about picking on the easy targets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically generate letter | Excel Discussion (Misc queries) | |||
New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) |