+ Reply to Thread
Results 1 to 3 of 3

Separate tabs from a spreadsheet

  1. #1
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275

    Exclamation Separate tabs from a spreadsheet

    I have a spreadsheet with about 6 tabs all referencing to different customers. The problem i have is if data is changed in tab1 and i need to send this to the customer all other tabs (and other customers info) goes with it.

    Is there a way of sending just the tab i require to the required customer?
    Another option is a seperate sheet for each so is there a way of seperating the current tabs into sheets of there own?

    No tabs data refers to another so no issue there.
    Otherwise is there a macro that will only send the required tab, something where the cover sheet has a list of tabs to customers which can be highlighted and sent

  2. #2
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: Seperate tabs from a spreadsheet

    To separate all the sheets, right click on a worksheet tab, select Move or Copy then New Book and save with a new file name. Repeat for the other sheets. Alternatively you could just do this for the sheet that you want to email, make sure you check the Copy box and save this as a temporary file. Your existing file will remain with all the sheets together.

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Seperate tabs from a spreadsheet

    Just a separate idea...

    Our company does not send Excel workbooks to anyone, ever. It's just not a safe environment. Not telling what hidden info or stuff can get forgotten and included...extra sheets just being one of the issues.

    We use PDF-Writer and print worksheets to PDFs and send customers/vendors PDFs. If I were going to write a macro to copy sheets to individual workbooks for emailing, I would have to have that macro print individual PDFs instead. Much safer end result.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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