+ Reply to Thread
Results 1 to 2 of 2

Selective columns in connected workbooks

  1. #1
    Registered User
    Join Date
    01-16-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    38

    Selective columns in connected workbooks

    I have a workbook with several columns, some of which are for internal company use only.

    Sometimes we need to send an updated list to business partners, but they don't need all columns.


    Is it possible to make another workbook which takes only specific columns, and excludes the stray info at the buttom of the original workbook?
    See examples.


    Alternatively: Would it be simpler to make an extra sheet in the original workbook, and somehow choose "Safe only this sheet to a new document" whenever somone requests the list?
    Attached Files Attached Files
    Last edited by Steffen_DK; 03-20-2014 at 05:41 AM. Reason: Forgot attachments

  2. #2
    Registered User
    Join Date
    01-16-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Selective columns in connected workbooks

    ----------
    Last edited by Steffen_DK; 03-20-2014 at 08:14 AM. Reason: Redundant post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple workbooks need to be connected and update together
    By GingerLeake in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2013, 08:06 AM
  2. Selective columns
    By Marvo in forum Excel General
    Replies: 143
    Last Post: 08-14-2011, 01:42 PM
  3. Deleting selective columns
    By T De Villiers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2006, 12:51 PM
  4. Copying Selective columns
    By Oldjay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2005, 06:05 PM
  5. Selective stacking of columns in a chart
    By Excel_lence in forum Excel General
    Replies: 2
    Last Post: 07-08-2005, 02:05 PM

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