+ Reply to Thread
Results 1 to 2 of 2

I want to populate multiple workbooks using data from one sheet is this possible

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    795

    I want to populate multiple workbooks using data from one sheet is this possible

    Hi guys,

    I am sharing a master report file (sampel/changed data)

    I want to know if this file has multiple times the same name of someone i.e. John Smith, can this row of data be inserted into a spreadsheet called John Smith? the unique reference being the name Johnbn Smith or the user ID (column A). I manage people and want to share a report with each individual of their performance. Any ideas pleaser?

    Thank you

    PO.S. Willing to consider the possibility of having multiple tabs populated for each individual and then is it possible to email the tab only to relevant staff memebr?
    Attached Files Attached Files
    Last edited by rayted; 06-29-2020 at 02:26 PM.
    Thanks,

    R.



  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: I want to populate multiple workbooks using data from one sheet is this possible

    This should create a workbook named for the person and saved to the same directory as the host workbook. The code should be copied to the standard code module1.

    Please Login or Register  to view this content.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

+ 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. [SOLVED] VBA selecting relevant data from master sheet to populate new workbooks
    By monkeypants in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-20-2015, 12:21 PM
  2. Replies: 2
    Last Post: 03-26-2015, 07:38 PM
  3. Replies: 9
    Last Post: 02-13-2015, 05:12 AM
  4. [SOLVED] Paste data from one sheet to specific sheet in multiple workbooks
    By tstrebel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2014, 01:34 PM
  5. Auto Populate Master Sheet from Multiple Other Workbooks
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2014, 10:22 AM
  6. Replies: 0
    Last Post: 07-29-2013, 03:00 AM
  7. [SOLVED] Consolidate Data from 1 Range on 1 Sheet in Multiple Workbooks to Master Workbook Sheet
    By Jennasis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2013, 06:11 AM

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