Hi -
I know this must be a very basic question, but I haven't found an answer that works for me in searching the forum (yes, I have performed several searches), so I'd appreciate your help.

I have a workbook with several tabs, one of which is a calendar/schedule (so no calculations or numeric values; just dates and text). Let's call it "Training File.xls", with "Schedule" being one of the worksheets in the file. If it matters, the schedule utilizes cells A1- AK69.

I need to have a different workbook that contains JUST the calendar/schedule (let's call it Vacation file.xls", with "Sheet 1" being the only worksheet), but I want the two schedules to be dynamically linked, so that if someone edits something in one (e.g., adds vacation days and shades them a particular color), it updates the other as well.

The files reside in separate folders on a network drive. Let's call them
"O:\dir1\subdir1\Training\Administrative Folder\Training Team Certs\Training File.xls" and
"O:\dir1\subdir1\Training\Administrative Folder\Vacation Calendar 2010\Vacation File.xls"

I know how to link a cell between sheets, but when I try to link the whole schedule (as either a range or an entire tab), no joy.

Thanks in advance for any assistance.