+ Reply to Thread
Results 1 to 3 of 3

Move or copy Tabs as text?

  1. #1
    Registered User
    Join Date
    01-20-2009
    Location
    Alabama
    MS-Off Ver
    Excel 2003
    Posts
    33

    Exclamation Move or copy Tabs as text?

    I have two tabs in my workbook. One named SPECS and the other is named COST. most of the data on the "SPEC" tab is filled automatically from my "COST" sheet. Is there a way when i move either the SPEC or COST tabs to a seperate workbook(for printing or to save individual files) that this data can be saved as text values while keeping the formatting?
    I am using both SPEC and COST tabs as templates and would like to export them regularly without keeping the linked cells but maintain the respective cell values. Is this possible?
    Thanks Again!

  2. #2
    Forum Contributor bentleybob's Avatar
    Join Date
    02-27-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    644

    Re: Move or copy Tabs as text?

    Highlight the entire worksheet (in the copy), hit Copy and the PasteSpecial Values. Or am I missing something in your question?

  3. #3
    Registered User
    Join Date
    01-20-2009
    Location
    Alabama
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Move or copy Tabs as text?

    Actually bentlybob . . . . That is exactly how to do it. However, I have a lady that is not experienced what so ever in excel and it totally blows her mind. So that got me to wondering if there was a way to do this with out copy and paste values to keep her from changing the values or sheet.
    But thanks anyway . . . . : )

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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