+ Reply to Thread
Results 1 to 3 of 3

Copy and Paste data automatically from master sheet to other sheets

  1. #1
    Registered User
    Join Date
    07-11-2014
    Location
    Eugene, Oregon
    MS-Off Ver
    2013
    Posts
    5

    Copy and Paste data automatically from master sheet to other sheets

    I have a workbook and on the Sheet 1 I have a list of employee names, department, and employment status. On Sheet 2 I have a list of employee names and trainings they have attended. On Sheet 3 I have employee names and their certifications. I want to be able to input new employees on Sheet 1 and have it automatically update the other sheets with those employees without disturbing the other data. I tried using a Microsoft query, but it messed up the other data. Ideally the code would just take the latest employee additions and add it to the bottom of the list on the other pages so they can be sorted alphabetically.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy and Paste data automatically from master sheet to other sheets

    Can you attach a workbook with some sample data showing your layout for each sheet? See the rules for attaching a workbook.

    http://www.excelforum.com/forum-rule...rum-rules.html

  3. #3
    Registered User
    Join Date
    07-11-2014
    Location
    Eugene, Oregon
    MS-Off Ver
    2013
    Posts
    5

    Re: Copy and Paste data automatically from master sheet to other sheets

    Here is an example. Thanks for help in an advance.
    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. [SOLVED] Automatically Copy Data from Multiple Sheets to a Master Sheet
    By Ryan_Brandt in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-10-2014, 06:45 AM
  2. Replies: 2
    Last Post: 07-17-2014, 09:46 PM
  3. Copy/paste data from different work sheets to master sheet
    By Guckmall in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2013, 08:23 AM
  4. [SOLVED] Copy paste values from sheets into one master sheet
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-20-2013, 10:52 AM
  5. Help with Copy and Paste Macro from Master sheet to other sheets
    By Livetorace27 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2013, 03:19 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