+ Reply to Thread
Results 1 to 2 of 2

Can you save multiple files that link directly to specific, separate, sheets?

  1. #1
    Registered User
    Join Date
    08-20-2013
    Location
    Washington, DC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Can you save multiple files that link directly to specific, separate, sheets?

    I work on a large master spreadsheet that contains information relevant to many different departments in my company. The workbook has separate sheets for each department. Is there a way that I can "save as" so that there are separate file icons in different folders on our shared drive that lead directly to each department's sheet?

    For instance, if someone is in department X's folder on our company server's shared drive, and they see the file labeled "department X spreadsheet" they can click it and go directly to "department X sheet" on the master workbook, while someone in Department Y's folder can click on "department Y spreadsheet" and it goes directly to "Department Y sheet" on the master workbook. Would that be possible?

  2. #2
    Registered User
    Join Date
    09-28-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: Can you save multiple files that link directly to specific, separate, sheets?

    Automatically that is challenging but not impossible. Like anything it's all in the details of the implementation and your specific parameters.

    What is probably your easiest option is to create a userform with buttons that take the users directly to their specific sheet. Then you can set the workbook open event to load the userform and ask what department the user is in. They will then click the button, and it will load their sheet directly.

    Would this work for you?

+ 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. [SOLVED] save all sheets as separate text files
    By Minnesaenger in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-06-2015, 02:25 AM
  2. [SOLVED] How to link two sheets in two separate Excel files
    By BNCOXUK in forum Excel General
    Replies: 3
    Last Post: 11-30-2012, 09:17 AM
  3. [SOLVED] VBA to save multiple worksheets as separate CSV files using name of worksheet
    By Yg74 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2012, 10:55 AM
  4. VBA to save multiple worksheets as separate CSV files using name of worksheet
    By titushanke in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2012, 08:08 AM
  5. How do I save sheets in a workbook to separate files?
    By Omzala in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-13-2005, 03:06 PM

Tags for this Thread

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