Results 1 to 8 of 8

How to copy a worksheet, WITHOUT linking it to the original workbook?

Threaded View

  1. #1
    Registered User
    Join Date
    08-17-2008
    Location
    Worthing, Sussex, UK.
    Posts
    46

    How to copy a worksheet, WITHOUT linking it to the original workbook?

    A simple one for you, but again my Google skills seem lacking. This must be common practice but until one knows the key combination...

    I have created a summary sheet with lots of formulas which analyse other sheets in a workbook. I want to copy this summary sheet to a seperate workbook to use as a template.

    Of course, the copying process always links the new (template) sheet to the original workbook it was copied from. How does one copy without forging this link? All I want are the formulas copied across totally unchanged; I really *don't* want to manually edit 50 or so formulas!

    Again, thank you.
    Last edited by Simon Lloyd; 10-03-2008 at 06:35 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. copy entire worksheet to current workbook
    By AJHWilliams in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2011, 08:47 PM
  2. Copy Worksheet for another Workbook
    By Hirayo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-03-2008, 02:50 AM
  3. Add multiple spreadsheets to single spreadsheet
    By tmotommyo in forum Excel General
    Replies: 5
    Last Post: 02-06-2008, 11:35 PM
  4. Macro to copy cells from 1 workbook to another
    By geff in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-05-2007, 06:02 AM
  5. Worksheet copy problem
    By Willow in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2006, 09:56 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1