Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking documents (non-numeric information
Hi
I have been asked to create 2 documents - 1) A Vacation Schedule for the Trainers and 2) A Master Training Calendar of where, what and who will be conducting Training The challenge I am facing is creating a link with these two documents which will allow simultaneous update to the Training Calendar about the status of the trainer (ie if they are on vacation). Can anyone offer any suggestion on how I can approach or solve this challenge? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking documents (non-numeric information
Carol
Presumably you need others to look at and use the Schedule and Calendar? So before you consider how to link these two documents (2 worksheets in one workbook) you really ought to design the documents i.e. the appearance and what information you need to show. For some ideas try an internet search for 'Free Excel Templates' - you may find one you can use or one to give you a starting point. When you've designed them you can then think about the links that are required to achieve your goal. "Carol" wrote: Hi I have been asked to create 2 documents - 1) A Vacation Schedule for the Trainers and 2) A Master Training Calendar of where, what and who will be conducting Training The challenge I am facing is creating a link with these two documents which will allow simultaneous update to the Training Calendar about the status of the trainer (ie if they are on vacation). Can anyone offer any suggestion on how I can approach or solve this challenge? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Documents | Excel Discussion (Misc queries) | |||
Linking 2 documents | Excel Worksheet Functions | |||
linking documents | Excel Discussion (Misc queries) | |||
Linking documents to automatically update | Excel Discussion (Misc queries) | |||
linking problem with closed documents | Excel Worksheet Functions |