Sharing information between workbooks

[Guest]

I am trying to set up a worksheet which shows differnt projects for different
departments and different members of my team. It will also show start and end
dates for those particular tasks.

This document will hold all the information for all of the projects.

Is it possible to then automatically sort all the data from a particular
department, or project or team member and have it update live to another
workbook?

Potentially the original document would have around 10 columns of data for
each project to be transferred,

and

the projects for a particular team member or project, would be all mixed up

thanking you in advance for your help

Nadia

 

[flummi]

Is this your main worksheet?

team project departm start end
Michael p1 sales 12.05.2006 30.09.2006
Peter p2 lab 01.04.2006 30.04.2006
Susan p3 accounts 01.05.2006 31.12.2006

What information do you want to export to another worksheet?
What is the criterion for the export?
What is the link in the other worksheet? MS Query? Cell references?

A bit more detailed info would help.

Hans

 

[Branch Rickey]

I am trying to have the text from sheet one in B2 appear onto sheet two
in B2 automatically. If I were to alter the text from sheet 1 <named
rosters> it would simply adjust on sheet two, too <s>.
<s>
Can anyone advise, regards,
(e-mail address removed)

 

[George Gee]

In B2 on sheet 2, type: =rosters!B2

Hope this helps

George Gee

"Branch Rickey" <[email protected]>
wrote in message
news:[email protected]...