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.

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.

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

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.