If name is the same between two sheets, have certain columns populate data

**steinhk6** · 02-16-2013, 06:43 PM

Ok new to programming VBA first off.

My problem is I have two sheets they both contain a long series of names, some of the names between the two sheets are the same.

For each name there are four columns containing data that I filled out.

Im wanting names that match between the two sheets to have that data in the four columns auto populate

Names are in Column A
Data in columns E through H

thanks in advance for the help.

**steinhk6** · 02-16-2013, 08:54 PM

Help please, Im sure this is easy for someone.

**PushCar** · 02-17-2013, 07:51 AM

If you change last row in cell A in Sheet1 the macro find in the Sheet2 the same name and copy the four values from Sheet2 columns E-H to Sheet1 to columns E - H.

Code for Sheet1:

Please Login or Register  to view this content.

and code for Module:

Please Login or Register  to view this content.

Here is the file:
data.xls

**steinhk6** · 02-17-2013, 06:52 PM

Thanks that is a start, but I need it to not just check the last row... For instance if 20 names are pasted into sheet two I need them to all auto populate the four columns if they were in the previous sheet, sheet1...

Thanks again for the help.

**PushCar** · 02-18-2013, 07:38 PM

If you only pasted into sheet two, this is for you:

Code for Sheet2:

Please Login or Register  to view this content.

Here is the file:
data.xls

**steinhk6** · 02-18-2013, 08:55 PM

Hmmm, that isn't working right...

The data from column A is moving into column B.

I still need the data from E-H Columns to auto populate for any name from A column that matched from sheet1 to sheet2.

Thanks again