Linking worksheets together

**k06** · 08-16-2012, 06:34 PM

I am creating a workbook that contains information for all the employees in our company. The 2 departments are production and performers and we would like the head of each department to be able to look at their employees information (and edit/rearrange to their suiting) and not have to see the other department. The thought is to have a main worksheet that has everyones information and then one for each of the 2 departments. The big problem is how to link them together so the information gets populated on each appropriate page and everyone can arrange the data to their hearts content.

Any thoughts would be greatly appreciated.

Thank you!

**FDibbins** · 08-16-2012, 07:54 PM

have you made a start on this workbook yet? i have some ideas on how this could be achieved, probably with pivot tables and/or filtering, but i dont want to start re-inventing thw wheel

if you have something, pleaae upload a sample for me to look at

**k06** · 08-17-2012, 08:09 AM

I have not created anything yet as I knew I needed to figure out an approach before I started going crazy.

**FDibbins** · 08-17-2012, 08:56 PM

it will be hard to deveop anything for you unless you have at least started to formulate what your "system" will look like and how it will be arranged. many toos are available in excel for what you need, including pivot tables and filters. having all data in 1 list is a good start tho, that always makes summries that much easier