Hi
I have a two tables.
TABLE ONE is a basic Gannt chart with employee name, milestones and timelines.
TABLE TWO is a summary and has the employee name and hours taken from TABLE ONE.
When I action the 'Sort & Filter' function any totals in Table Two does not connect to the correct employee name.
How do I adjust the formula to properly record the correct hours associated with the employee name after the sort function.
Ideally I want TABLE TWO to track the employee hours automatically whenever the columns are sorted.
Bookmarks