+ Reply to Thread
Results 1 to 5 of 5

Sharing Cells/Columns Between Workbooks

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2007
    Posts
    3

    Sharing Cells/Columns Between Workbooks

    I want to share some data between workbooks that I have. So that when data is entered in Book1 I want that data to also be shown in Book2. But if the user of Book2 decides to change the data, it should be reflected in Book1.

    Currently I see two ways of solving this.

    1: Using the share workbook feature with linked cells. I'm not sure how to go about setting up my workbooks using this method though.

    2: Using VBA coding. I have the data linked right now so if changes are made in Book2 it changes Book1.

    Please Login or Register  to view this content.
    This code only works one way right now. So if the user wants to make changes in Book1 after it won't work.
    Last edited by johnmiko4; 08-14-2013 at 11:26 AM.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Sharing Cells/Columns Between Workbooks

    Is it impossible to place the workbook in a shared location and simply edit the same one?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    06-20-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Sharing Cells/Columns Between Workbooks

    It's possible but not preferred. Book1 is for management and Book2 is for the Engineers. The Engineers aren't supposed to see some of the data on Book1

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Sharing Cells/Columns Between Workbooks

    So will they be in a shared location? Will they be open at the same time?

    Even if we come up with a solution there are going to be a lot of variables that could cause this macro to fail. It might be pretty buggy.

  5. #5
    Registered User
    Join Date
    06-20-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Sharing Cells/Columns Between Workbooks

    The files will be in a shared location and they may be open at the same time. Ya I know, I think I'm going to have to test if the workbook is open first before this code is executed

+ 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. sharing workbooks
    By PPatrick in forum Excel General
    Replies: 2
    Last Post: 01-22-2013, 07:53 PM
  2. Excel 2007 : Sharing workbooks
    By dwokz in forum Excel General
    Replies: 1
    Last Post: 11-04-2010, 02:49 PM
  3. Excel 2007 : Sharing Workbooks between PC and Mac
    By bosstone75 in forum Excel General
    Replies: 2
    Last Post: 12-10-2009, 08:42 PM
  4. Sharing Workbooks
    By Nigel Brown in forum Excel General
    Replies: 1
    Last Post: 10-13-2006, 08:42 AM
  5. [SOLVED] Sharing Excel Workbooks
    By JDC in forum Excel General
    Replies: 2
    Last Post: 01-29-2006, 03:10 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