+ Reply to Thread
Results 1 to 2 of 2

Table that reads from another one, but make personal changes?

  1. #1
    Registered User
    Join Date
    02-25-2012
    Location
    Norway
    MS-Off Ver
    MS365 v.2202
    Posts
    37

    Table that reads from another one, but make personal changes?

    Hello!
    I have a worksheet with a table that employees need access to. Basically a to-do-list that every employee needs to do even if another one has done it.
    Now and then the boss adds entries, so each employee need an updated version of the file.

    The file contains a list of about 50-60 entries, it will be hard for employees to remember which one they have done.
    I could add a column with each employees name and they can write “yes” or something when they have done it.

    However, the file is located on a network drive that is write-protected for most employees since they have limited computer knowledge and might screw things up. If they copies the file to their computer they won’t have an updated version.

    Maybe it’s possible to make a secondary excel-file that reads the table from the main one and employees could then check entries that they they have done in their file? Or something else?

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Table that reads from another one, but make personal changes?

    Depending on your data layout, as a sample was not attached and we cannot know how it looks and everything, my best assumption would be that you ca create a file on the network drive in a folder for each employee and from all the files data to be updated in the main one, using VBA. But as I said is just an assumption.
    Click the * to say thanks.

+ 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. Replies: 3
    Last Post: 05-25-2018, 07:20 PM
  2. Replies: 1
    Last Post: 03-14-2014, 07:06 PM
  3. Replies: 1
    Last Post: 11-13-2013, 01:13 PM
  4. Replies: 0
    Last Post: 05-10-2012, 09:22 AM
  5. Calling Personal.xls functions without needing a 'personal.xls!' prefix
    By Skywalker in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-08-2010, 02:43 AM
  6. VLOOKUP Personal.xls - how to make values update automatically
    By maff in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-18-2008, 03:23 PM
  7. [SOLVED] How do I make a Schedule Appointment for personal meeting
    By Ashleyt in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-02-2005, 09:05 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