+ Reply to Thread
Results 1 to 4 of 4

How to add macro to copy data from a master data worksheet to another worksheet by name.

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    Long Island, NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question How to add macro to copy data from a master data worksheet to another worksheet by name.

    Hello! I am very new to macro and programming in Excel. I was hoping someone can help. I am trying to copy a row of data from 1 worksheet which is my master data sheet to another specific worksheet with only specific employee names which may be duplicated on the second worksheet.

    Example:

    1) data on master worksheet.
    2) certain employee names on worksheet 2 with no data.
    3) look for employee name plus any duplicate employee name on worksheet 2 and copy data from master worksheet.

    Does this make sense as it does in my head and is this something that can be created?

    Thanks for any help you may provide.

    *please keep in my I am not a programmer.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,775

    Re: How to add macro to copy data from a master data worksheet to another worksheet by nam

    Hello. It would be helpful if we had a little more information. In which column in the Master sheet and in Sheet2 are the employee names? Does Sheet2 contain any data other than the names? Are you using column headers in Row 1 of the sheets? If you could post a sample file, it would be easier to understand.

  3. #3
    Registered User
    Join Date
    02-04-2013
    Location
    Long Island, NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to add macro to copy data from a master data worksheet to another worksheet by nam

    Thanks for your response. Basically I want to type in an employee name in sheet 1 and have it find and populate the data from that specific employee in the master sheet. I have enclosed a sample file. Lets just say I type in Employee F in Row G of sheet1, how can it find that employee in the Master Data tab and populate the data.Test Macro Sheet.xlsx

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,775

    Re: How to add macro to copy data from a master data worksheet to another worksheet by nam

    Hi. Try the following code. You will be prompted to enter the name to search. You must make sure that you type it exactly as it is entered in your Master Sheet (not case sensitive).

    O
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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