Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I filter data from a master worksheet to other worksheets
I am pretty new to this so excuse my ignorance.
I finally got Auofilter to work so i am pretty happy. We have a master sheet which has all the tasks all employees are working on. We use an x to dictate a column where someone has to do it. The master work sheet may look like this Date Task EmpName1 EmpName2 EmpName3 1-nov Call client x 1-nov Attend meeting x x 2-nov Photocopy Doc x I created a workheet for each employee by referencing everything in the master sheet (i.e for a1 in EmpName1 i just put =master!a1) - and then applying an autofilter with "x" as the criteria for each employee worksheet. so the EmpName1 worksheet would look like this Date Task EmpName1 EmpName2 EmpName3 1-nov Call client x 1-nov Attend meeting x x This all works really well except when new tasks are added to the Master worksheet - for the task to show up on each employees worksheet they need to go and "re-filter" using the x selection to bring up the new tasks. Ideally I would like this to be automated. is this possible? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Consolidate Several Workbooks into One | Excel Worksheet Functions | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
Merge Worksheets | Excel Worksheet Functions | |||
access my data from my master worksheet while calculation is don. | Excel Worksheet Functions |