Vba to compare two sheets for matches and if found Move all data pertaining.

Hello World

I have learned so much from this Forum over the past year and have accomplished so much by searching, however there comes a time where I have no clue where to start and this example is one of those times.

I have 3 sheets named New Customers, Customer sales & Line Extensions.

I need to find code to do the following:
1. Search through Sheets("Customer Sales"). Range("A:A") to find the names in Sheets("New Customers"). Range("A:A")
2. Copy all the data under that name to Sheets("Line Extensions") as per outcome in attached sample sheet.
3. If no match, then do nothing.

Any idea where I can start...

Well...allrighty then

This so far Finds the names as long as they are the same...A start I guess.

Please Login or Register  to view this content.

Mike...You area superstar..Seems to work. Will try and figure out the setup.
IF not, will most definately come back to you for assistance. Would not have figured this out....

Wow, i wish i had the ability to "JUST THROW CODE TOGETHER QUICKLY"
Have got such a long way to go lol.... Mike, it works just perfectly as is.

Thanks again.