software

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

Is this your main worksheet?

teamprojectdepartmstartend
Michaelp1sales12.05.200630.09.2006
Peterp2lab01.04.200630.04.2006
Susanp3accounts01.05.200631.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
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 lt;named
rostersgt; it would simply adjust on sheet two, too lt;sgt;.
lt;sgt;
Can anyone advise, regards,

--
Branch Rickey
------------------------------------------------------------------------
Branch Rickey's Profile: www.excelforum.com/member.php...oamp;userid=31451
View this thread: www.excelforum.com/showthread...hreadid=510900
In B2 on sheet 2, type: =rosters!B2

Hope this helps

George Gee

quot;Branch Rickeyquot; gt;
wrote in message
news:Branch.Rickey.232z1n_1139687883.9222@excelfor um-nospam.com...
gt;
gt; I am trying to have the text from sheet one in B2 appear onto sheet two
gt; in B2 automatically. If I were to alter the text from sheet 1 lt;named
gt; rostersgt; it would simply adjust on sheet two, too lt;sgt;.
gt; lt;sgt;
gt; Can anyone advise, regards,
gt;
gt;
gt;
gt;
gt; --
gt; Branch Rickey
gt; ------------------------------------------------------------------------
gt; Branch Rickey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31451
gt; View this thread: www.excelforum.com/showthread...hreadid=510900
gt;