Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying sheet without changing references/formulas (2000 SP3)

    Hi Everyone! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Here's the scenerio: <UL><LI>WorkbookA has 3 worksheets: SheetA, SheetB and SheetC
    <LI>WorkbookB has 5 worksheets: SheetA, SheetB, SheetC, and two newly created sheets: NewSheetA and NewSheetB
    <LI>SheetA, SheetB and SheetC are identical in both workbooks
    <LI>NewSheetA and NewSheetB have all kinds of cells referencing cells on SheetA, SheetB and SheetC [/list]How can I copy NewSheetA and NewSheetB to WorkbookA without the references changing to include "=[WorkbookB.xls]..." all over the place?... I simply want the formulae and references to remain exactly the same, thereby referencing the cell in the current workbook... Does that make sense?.... Is this possible?? Seems as though it should be...

    Thanks in advance!

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copying sheet without changing references/formulas (2000 SP3)

    If you copy or move NewA and NewB from workbook B to workbook A you can then change the "links" in A (which will reference wb [img]/forums/images/smilies/cool.gif[/img] to reference wb A.
    <UL><LI> Save both wb's - particularly, save wbA with a new name - just in case it doesn't work...
    <LI> Copy the sheets NewA and NewB from wbB to wbA the version with the new name
    <LI> Close wbB
    <LI> Save wbA, then open the menu item "Edit | Links this will open a dialogue box with all the links listed
    <LI> Click on "Change Source" on the right (if there is more than one source listed, make sure you have selected the reference to wbB)
    <LI> This opens a regular file list dialogue box - click on the name of wbA and Okay, then clear the 'edit links' dialogue box (the link to wbB will have disappeared)[/list]

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying sheet without changing references/formulas (2000 SP3)

    Worked perfectly! Thanks! I appreciate the help... I love it when I learn something new... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •