Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Links
I have 2 separate workbooks. One is called 'Pack A' and the other one is
'Pack B'. 'Pack A' began with a worksheet called "December 2004" and it is a very detailed sheet. 'Pack B' links to 'Pack A'. 'Pack B' also has a worksheet labeled "December 2004". I would like to go into 'Pack A' and create a copy of the worksheet "December 2004" then rename the copied worksheet to "January 2005". I then would like to do the exact same process to 'Pack B'. My problem lies in making "Pack B' "January 2005" link to 'Pack A" "January 2005" instead of 'Pack A' "December 2005" no matter what I try I can't get this accomplished. Is there anyone that could possibly help me, please? |
#2
|
|||
|
|||
Hi Troy,
Try the following: 1. Open Pack A 2. Copy December 2004 worksheet 3. Rename it January 2005 4. Open Pack B 5. Copy December 2004 6. Rename it January 2005. The links in Pack B's January 2005 will reference Pack A's December 2004 7. Now use the Replace function (on the toolbar, Edit/Replace). 8. A menu box will appear. Do the following: a) For Find What enter "December 2004" (without the quotes). b) For Replace With enter "January 2005" (w/o quotes). c) Select Options. Within should be "Sheet". In Search, choose "Rows" or "Columns". Look in should be "Formulas". d) Select "Replace All" This should update all the links for you. Regards, Scott "Troy" wrote: I have 2 separate workbooks. One is called 'Pack A' and the other one is 'Pack B'. 'Pack A' began with a worksheet called "December 2004" and it is a very detailed sheet. 'Pack B' links to 'Pack A'. 'Pack B' also has a worksheet labeled "December 2004". I would like to go into 'Pack A' and create a copy of the worksheet "December 2004" then rename the copied worksheet to "January 2005". I then would like to do the exact same process to 'Pack B'. My problem lies in making "Pack B' "January 2005" link to 'Pack A" "January 2005" instead of 'Pack A' "December 2005" no matter what I try I can't get this accomplished. Is there anyone that could possibly help me, please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Individual Links | Excel Discussion (Misc queries) | |||
Links w/in same workbook not working | Excel Discussion (Misc queries) | |||
How to find cells with links to other workbooks? | Excel Discussion (Misc queries) | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |