+ Reply to Thread
Results 1 to 4 of 4

Transfer data from master file to individual sheet automitically when updated

  1. #1
    Registered User
    Join Date
    08-30-2016
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    13

    Transfer data from master file to individual sheet automitically when updated

    I am working on a document that has a master sheet. I need to take the Master sheet data and have it transfer to individual sheets based on the data in Column B and update each time the Master is updated. I have attached a copy of my file.
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,317

    Re: Transfer data from master file to individual sheet automitically when updated

    Try this...

    Right click on the sheet containing the data (Master tab) and paste this code in...

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    08-30-2016
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: Transfer data from master file to individual sheet automitically when updated

    Thank you. Is there a particular place I should add it?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,317

    Re: Transfer data from master file to individual sheet automitically when updated

    Right click on the sheet containing the data (Master tab) and paste this code in...
    You can also see...

    http://www.rondebruin.nl/win/code.htm

    It's sheet module code

+ 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] Copy the data from Master file and paste into individual excel file as per criteria
    By Vikas_k in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-30-2023, 09:15 AM
  2. Transfer data from Master Sheet to individual sheets
    By marquint in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-09-2016, 07:57 PM
  3. Replies: 1
    Last Post: 05-08-2015, 10:38 AM
  4. Extrat data from master into 130 individual sheet
    By mkd071011 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-04-2015, 09:09 AM
  5. Replies: 3
    Last Post: 01-10-2012, 06:58 PM
  6. Need a macro to update data from raw file to individual sheets of master
    By Varunv in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-31-2011, 01:19 PM
  7. Master data to separate sheet & individual book?
    By motown in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-29-2009, 02:59 PM

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