View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard R
 
Posts: n/a
Default search and export multiple records

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