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 worksheet to new workbook exactly as is.. (2000 SR-3)

    Okay... I have this awful feeling that I'm asking the dumbest question ever asked... <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    but I'm having trouble with this and I need to get it done YESTERDAY...

    I created a new worksheet inside this 20-odd page workbook... I created all kinds of formulas referencing different cells on other sheets.... Works great... but now I have to copy this sheet to other workbooks with the same sheet names and areas... How do I keep the sheet exactly as it is when copying over to the new book?

    For example if a particular cell contains "='US dir'!BP1545 in the old book... I want it to stay exactly that...
    I'm sure this must be possible but no matter how I do it, it gets altered...

    Can anyone help me?
    TIA

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying worksheet to new workbook exactly as i

    You need to select Edit|Links and make the new Workbook link to itself. The deault is that the copied Worksheet links back to the Workbook out of which it was copied.
    Gre

  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 worksheet to new workbook exactly as i

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> so much... Appreciate it!

Posting Permissions

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