Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
We have an Excel spreadsheet for all 1200 of our employees with name,
department name, SSN and birthdate. I have added another field to sort by birthmonth only. I can easily sort by the birthmonth, but I need to produce separate letters to each of the relevant department heads IF they have an employee due a test each month, listing the employees only for that department. I would like to automate this procedure with linked files or a query or some other way rather than do cut & paste, if possible, but I am at a loss how. Can anyone help me out? Thanks, Richard -- Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions |