+ Reply to Thread
Results 1 to 2 of 2

Live update between 2 different spreadsheets

  1. #1
    Registered User
    Join Date
    11-05-2015
    Location
    London, England
    MS-Off Ver
    Newest excel for mac
    Posts
    7

    Live update between 2 different spreadsheets

    Hi all

    I am making some improvements to efficiency within my office, and the project I am currently working on could be so good, if I can figure out one thing! I shall explain what I am trying to achieve and hopefully someone can help!

    I have:

    A Master Spreadsheet (which acts as an internal intranet, of which I open in the morning and then 10 others open the read only for use in the day - this stays open)
    A sales tracker (which is opened for every sale and then added to the tracker)

    What I would like:

    To be able to update the sales tracker, close the sales tracker and this then updates a tab within the master spreadsheet for all users, whilst still open.

    Is this at all possible? I just want a live feed to the "intranet" for everyone to be able to see where we are at any point in the day.

    Hope this makes sense, and hope its possible!

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Live update between 2 different spreadsheets

    misterjam: You might look into sharing the workbook. All your people can work on and save the tracker at the same time. There's some loss of functionality, such as hyperlinks, and conditional formatting but it might be an option for your group. Saves a lot of updating from various sources.
    Pete

+ 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. Live Update results to web
    By mjcloward in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-26-2012, 10:50 AM
  2. Compare two spreadsheets for differences from live CSV on web
    By noefresh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2011, 01:51 PM
  3. Live Linked Spreadsheets
    By Down-low in forum Excel General
    Replies: 2
    Last Post: 07-31-2011, 09:06 AM
  4. Losing Formulas after Live Office Update
    By grsnipe in forum Excel General
    Replies: 0
    Last Post: 03-25-2011, 03:02 PM
  5. how to make live update of cells?
    By adds007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2010, 08:52 PM
  6. Live update of excel from databsae
    By Draperman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2009, 10:34 AM
  7. Live update with excel?
    By Zirus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-27-2007, 12:17 PM
  8. Replies: 5
    Last Post: 05-05-2005, 11:06 AM

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