+ Reply to Thread
Results 1 to 2 of 2

Managing several Independent Workbooks in one Excel File

  1. #1
    Registered User
    Join Date
    10-02-2020
    Location
    New York
    MS-Off Ver
    Office 3654
    Posts
    3

    Managing several Independent Workbooks in one Excel File

    Hello, I have a question that might have a simple answer and perhaps I am complicating my thinking unnecessarily.
    I need a way to manage multiple independent workbooks in one excel file. For example, let’s say there are workbooks titled January, February, March and so on up to December in one excel file title 2020. Each of the workbook, e,g, January workbook contains three to four worksheets (sales, expenses, profit, etc) that are interconnected via formulae, pivot table, etc. I want to make multiple copies of January workbook with in the same file. The new workbooks should preserve the relationships within the workbook but not across workbooks. For example, the worksheets in February workbook should not interact with worksheets in January workbook. Could you help me please? I google searched but could not find what i wanted to do. Thanks. Kesavan

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Managing several Independent Workbooks in one Excel File

    If you just save say the Jan workbook in the 2020 directory as Jan-Backup then Jan-Backup will have all the formulas and external connections to Feb, Mar, ... and so on. Is that what you need? The other main workbooks(Feb, Mar, ...) will not connect to the new Jan-Backup because the link name is different, as the link name incorporates the file name.

+ 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] Need help managing multiple open workbooks to give the focus to the correct workbook
    By catalystsystems in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2017, 02:17 PM
  2. Replies: 6
    Last Post: 09-01-2017, 12:36 AM
  3. Managing MANY different macros within a single personal file?
    By sami770 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2014, 01:57 PM
  4. Managing Tabs in large Workbooks
    By jjock in forum Excel General
    Replies: 1
    Last Post: 09-24-2013, 12:01 AM
  5. Need Macro for managing information between two excel workbooks
    By mikhil16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 05:11 PM
  6. Replies: 0
    Last Post: 12-27-2012, 05:40 PM
  7. managing 2 workbooks at once
    By o811marine in forum Excel General
    Replies: 3
    Last Post: 07-23-2012, 10:25 AM

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