Need Help..Match A Cell Values and Transfer to Different Sheets

Hello Everybody,

I need some help regarding this step. I have Information found on Sheet 1. I need the program to take the value found in Column B and try to find matches found on Sheet 2 in Column B. Here's the thing it is only going to take the first 3 characters found in the Cell on Sheet 1. But in sheet 2 it will need to pull all information that matches those 3 characters. I included a sheet on what the finished product should look like for two of the sheets. If the program finds a match it will transfer the original and the copied match to a sheet Named "Name". The correct format can be found on "Finished Sheet Name". If no matches are found it will place the original information from Sheet 1 onto a sheet called "New". Thanks for your help. I've been trying for days and I still can't figure this out.

Test2.xlsm

Try this:

Please Login or Register  to view this content.

Thanks, Is there a way to make any value from Sheet 1 that doesn't match anything from Sheet 2 to get transferred to the Sheet called "New"?

Don't know why but the last post didn't register. So I'm reposting it.

"Thanks, Is there a way to make any value from Sheet 1 that doesn't match anything from Sheet 2 to get transferred to the Sheet called "New"?"

Like this:

Please Login or Register  to view this content.

Thank You!!