View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kelly Kelly is offline
external usenet poster
 
Posts: 132
Default action items- sorting through multiple worksheets by employee name

I've got action items from various meetings each in their own 'meeting' tab.
The problem is, when a new meeting tab is created, or an old one is updated
with a new action, the person assigned to the actions won't know about it
unless they hunt for it (and most times they arent aware of it until it is
too late!)

Is there anyway to create something where each persons' actions (from the
entire workbook) can be sorted out and that would automatically update when a
new entry was made with their particular name assigned to the task?

I am using Office 2003 by the way...