Hello and Thank you for your reply!
I have attached and image of the two table, and the macro that i have been trying to get to work, no luck so far
I'm a SQL and PHP and CF person. Excel is so Alien to me right now but i need to learn it seeing it playz a big part with my company.