+ Reply to Thread
Results 1 to 8 of 8

Syncing multiple workbooks

  1. #1
    Registered User
    Join Date
    02-15-2018
    Location
    California
    MS-Off Ver
    2016
    Posts
    4

    Question Syncing multiple workbooks

    In workbook 1, columns A-D have employee info (first name, last name, division, and supervisor) and columns E-H have dates trainings were completed
    In workbook 2, columns A-D have the same employee info but columns E-K are tracking employee schedules and attendance
    In workbook 3, columns A-D have that same employee info again, but columns E-I are tracking employee outcomes
    (Each workbook is tracking additional info on other tabs, hence not having the previously mentioned sheets all in the same workbook)
    I need a way to sync columns A-D between all three workbooks so that when I add an employee or change an employee's supervisor in workbook 1, it will show up in the other workbooks. I tried to use a reference formula but if I add an employee on on line 6 of workbook 1, workbook 2 won't move the employee schedules to leave a blank line for the new employee, so everyone after the new employee will have the wrong schedule.
    I've also tried Get & Transform with the same problem.
    Does anyone have any ideas??
    I'm using Excel 2016.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Syncing multiple workbooks

    Can you attach a desensitised sample workbook?

  3. #3
    Registered User
    Join Date
    02-15-2018
    Location
    California
    MS-Off Ver
    2016
    Posts
    4

    Re: Syncing multiple workbooks

    Here are workbooks 1 & 2
    Attached Files Attached Files

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Syncing multiple workbooks

    You want to sync from other workbooks to Tracking only?
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  5. #5
    Registered User
    Join Date
    02-15-2018
    Location
    California
    MS-Off Ver
    2016
    Posts
    4

    Re: Syncing multiple workbooks

    Here's workbook 3
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-15-2018
    Location
    California
    MS-Off Ver
    2016
    Posts
    4

    Re: Syncing multiple workbooks

    The opposite, actually
    I'm trying to set it up so that any time an employee is updated or added in tracking, he/she will also be updated/added in workbook 2 and workbook 3

  7. #7
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Syncing multiple workbooks

    ok, start over
    main file: workbook1 (it will manage columns A-D for workbooks 2 and 3)
    workbook 1 get info from wb 2 and 3 from columns after D ->> E,F, etc
    user cannot change columns A-D but only columns after D
    manager cannot change columns after D but can change A-D
    user cannot get info (except A-D) from wb 1 and wb2 cannot get infor from wb3 and vice versa
    manager can get all info from wb 2 and 3
    user can add info to all rows visible on his wb but no more than manager share with him

    so if there is 34 rows - user can add any data to 34 rows and manager can get all info from these 34 rows from users

    but uers can get data from 34 rows but only from columns A-D

    twisted, I know
    Last edited by sandy666; 02-15-2018 at 02:45 PM.

  8. #8
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: Syncing multiple workbooks

    Ok, try this....
    unzip and move sync folder directly to C:\
    if you want another location you will need to change filepath to all workbooks (and probably you'll do that )

    but for now to check how it works: C:\sync\(files)
    Attached Files Attached Files

+ 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. Syncing multiple Worksheets to same size and shape
    By datanyc in forum Excel General
    Replies: 0
    Last Post: 08-24-2016, 02:29 PM
  2. Syncing multiple excel files
    By Fpaiva in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2015, 04:56 PM
  3. Syncing worksheets--Possible?
    By aherring in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-16-2014, 05:03 PM
  4. Replies: 4
    Last Post: 01-31-2014, 06:22 AM
  5. Syncing Pivot Tables in 1 tab and multiple tabs
    By eugeneevans in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-29-2014, 04:55 PM
  6. Need advice: syncing multiple shared workbooks with a centralized workbook
    By evanzo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-09-2013, 10:59 AM
  7. Syncing worksheets
    By krombie19 in forum Excel General
    Replies: 2
    Last Post: 07-05-2012, 12:38 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