Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sharing information between workbooks
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sharing information between workbooks
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sharing information between workbooks
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, -- Branch Rickey ------------------------------------------------------------------------ Branch Rickey's Profile: http://www.excelforum.com/member.php...o&userid=31451 View this thread: http://www.excelforum.com/showthread...hreadid=510900 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sharing information between workbooks
In B2 on sheet 2, type: =rosters!B2 Hope this helps George Gee "Branch Rickey" wrote in message news:Branch.Rickey.232z1n_1139687883.9222@excelfor um-nospam.com... 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, -- Branch Rickey ------------------------------------------------------------------------ Branch Rickey's Profile: http://www.excelforum.com/member.php...o&userid=31451 View this thread: http://www.excelforum.com/showthread...hreadid=510900 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing Excel Workbooks | Excel Discussion (Misc queries) | |||
Issues of sharing workbooks | Excel Discussion (Misc queries) | |||
Sharing Information Between Workbooks | Excel Worksheet Functions | |||
Looking up information in 2 different workbooks | Excel Discussion (Misc queries) | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) |