action items- sorting through multiple worksheets by employee name
in [General]
|
Prev: How do I copy a custom footer to other sheets
Next: Is there a way to have an excel read only auto refresh after save
From: kelly on 14 May 2010 10:50 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...
From: Jim Thomlinson on 14 May 2010 11:01 The short answer is no. There is nothing easy to do what you are asking. Generally speaking XL is not the correct tool for what you are trying to do. A database really would be a much better solution. Your situation being what it is however you could try consolidating all of the meeting tabs into a single tab using code from the link below. Then it would just be a matter of filtering the data... http://msdn.microsoft.com/en-us/library/cc793964.aspx -- HTH... Jim Thomlinson "kelly" wrote: > 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...
From: Herbert Seidenberg on 14 May 2010 14:43
Excel 2007 Tables Tables are now dynamic in both dimensions, and are location independent. Consolidate, filter and concatenate with macros that use Table references, not "A1:B10" or "R1C1: R10C2" . http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_14_10.xlsm |