+ Reply to Thread
Results 1 to 2 of 2

Search for & open, or copy & open, workbooks, maybe contain multiple workbooks in one?

  1. #1
    Registered User
    Join Date
    03-30-2016
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    6

    Search for & open, or copy & open, workbooks, maybe contain multiple workbooks in one?

    Hello,
    Here's what I want to do: For Q&A, I have a number of employees, each of which have a total of 20 instances of work checked per year, all with identical reports, where say 10 or so questions are answered with 1 of 3 drop down menu answers. So, I've created individual workbooks for each employee, with the 20 identical questionnaires as separate sheets, and a sheet at the end giving totals for each answer.
    I haven't figured out how to have several employees each with 20 sheets in a single workbook, so I figure I can have an individual workbook for each employee, with the figures I'm looking to compile being identical in placement, and then I can figure out how to create a "master" workbook to compile the totals from each individual workbook to amass total results of the team.
    Being able to have each employee detailed as above in a single workbook would be nice, and I'll accept how to do it if it's possible, but what I'm really looking for is this:
    On the "master" workbook, in a single column labeled "Name", I would like to type in a person's name (if not there already), and have Excel (2010 standard, with Windows 7) look in a particular Windows directory for a file containing that particular name (eg: Jones, Excel would search for Jonesfile.xlxs) and said file exists, open it. However, if Jonesfile.xlxs does NOT exist, then I would like Excel to copy "Masterfile.xlxs" as "Jonesfile.xlxs" to that directory and open it. If "Jones" already exists in the "Name" column, then clicking on it should open the "Jonesfile.xlxs" workbook.
    I appreciate any help offered, within the Forum rules, of course.
    Thank you!
    Last edited by Stupidio; 03-31-2016 at 07:11 AM. Reason: Non-compliance with Rule 1 of Forum Rules

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,371

    Re: Master Worksheet?

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

+ 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. Macro to copy data from multiple worksheet cells in to a single Master worksheet
    By thunt13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2015, 03:24 PM
  2. [SOLVED] Macro to Copy Master Worksheet create and paste in new auto named worksheet
    By TheRealLethality in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2014, 12:46 AM
  3. Merging multiple excel files in a folder into one master worksheet in a new worksheet
    By johnny_canuck in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-22-2013, 12:20 PM
  4. Replies: 0
    Last Post: 07-01-2013, 10:19 AM
  5. Update Excel Worksheet from Master Worksheet located on FTP Server
    By mmctague in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2012, 08:36 PM
  6. Drop Down List to Copy Entire Contents of Worksheet into Master Worksheet
    By mrmartin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-14-2011, 10:54 PM
  7. Multiple Worksheet to gather in Master Worksheet minus one Wroksheet
    By Navymagirl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2010, 12:09 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