move 2 worksheets & keep the links
Excel '97 --------
I want to move 2 worksheets (one is linked to the other) to another file. It is an Excel file called ''Xmas List.'' These are the 2 worksheets: List Relatives The Relatives worksheet is linked to the List worksheet (the List worksheet includes everybody). I want to move the 2 worksheets to an Excel file called ''Xmas 2003-2008.'' Xmas 2003-2008 has these 5 worksheets: 2003 2004 2005 2006 2007 But when I copy the 2 worksheets into ''Xmas 2003-2008,'' the ''Relatives'' worksheet stays linked to the ''List'' worksheet in the ''Xmas List'' file. Within the ''Xmas 2003-2008'' file, how do I make ''Relatives'' link to ''List''? Jack |
All times are GMT +1. The time now is 01:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com