+ Reply to Thread
Results 1 to 3 of 3

Worksheet Connection

  1. #1
    Registered User
    Join Date
    06-09-2021
    Location
    Charlotte, NC
    MS-Off Ver
    10
    Posts
    2

    Worksheet Connection

    Is there a way I can have workers submit their work survey results to a master workbook?

  2. #2
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    901

    Re: Worksheet Connection

    Yes it is, its easier and safer if you have a standardized or central location where the master will be located as well as their surveys.
    One way would be to link their workbooks with your master. meaning having references from theirs to the master.
    Another would be to setup your master to process their surveys and populate your master with the accumulated data.

    All depends on how you want to handle and how the surveys are currently being done.. if you dont want to disrupt the way things are done, i would probably go the route of processing their files into your master so they dont have to change what they are doing and you can just consume the data as you need it.
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,158

    Re: Worksheet Connection

    Duplicate thread here
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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: 0
    Last Post: 11-16-2019, 09:05 AM
  2. [SOLVED] Delete connection after importing csv file into worksheet.
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2019, 09:49 AM
  3. Replies: 2
    Last Post: 05-15-2015, 04:12 PM
  4. Need Help Creating SQL Connection String from Excel Worksheet
    By BruceWayneIII in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2015, 04:26 PM
  5. Replies: 2
    Last Post: 06-03-2014, 03:56 PM
  6. transferring defined names from one worksheet to another via data connection?
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-13-2014, 02:45 PM
  7. Problem establish connection to an excel worksheet via DDE from DDE client.
    By najsel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2011, 03:41 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